Please can somebody help me??!!
I have done the following calculation in a form:
3750*2.25%=84.375
I now want to minus this figure from the original £3750. This equals £3665.625 which is correct.
The problem I am having is that when I show the 2 values to 2 decimal places on comes out as £84.38 and the other £3665.63. This means that the figures look like they are 1p out.
Please can somebody help me to make Access round the first figure up before it subtracts it from the second (like the roundup function in Excel).
Thanks in advance
I have done the following calculation in a form:
3750*2.25%=84.375
I now want to minus this figure from the original £3750. This equals £3665.625 which is correct.
The problem I am having is that when I show the 2 values to 2 decimal places on comes out as £84.38 and the other £3665.63. This means that the figures look like they are 1p out.
Please can somebody help me to make Access round the first figure up before it subtracts it from the second (like the roundup function in Excel).
Thanks in advance