Ida and Murali have been requesting the insurance for the same shipment twice. With the different excel files maintained in two separate PCs, can't blame them for that!
I therefore have revamped the Access.db. They now can just open and see whether that shipment has been insured, and click "Print Today" then the request note can be printed.
Was, however, having a problem of rounding up numbers to the next million. Round([Number],2) can only rounding up 6,231,123.67 to 6,231,124.00 where what I wanted was only 6.2 million.
Reckying around, thinking hard when I decided to first divide the [Number] with 1 million then rounding up to two decimal points then mulptiply that with 1 million back.
This goes: Round(([Number]/1000000),2)*1000000.
What a smart ass!!
No comments:
Post a Comment