Rounding and storing to 2 decimal places in Access
Posted on 2012-04-11
I am being sent a fixed length file which I'm importing into Access 2003, and then converting the data to compare against another table where the values are stored to 2 decimal places in USD.
FldA is an example of a value in the fixed length file, and its cobol format is PIC 9(9)v9(6). This value is in local currency so it needs to be translated to USD, and then rounded and stored to the same 2 decimal places. For the rounding, 5 and higher should be rounded up, 4 and lower should be rounded down.
This is as far as I got: [FldA]/1000000*FXRate
The rounding and storing to 2 decimal places is stumping me...