Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Grunster
-
Form Footer
Please can somebody help with what is probably a simple query?! I have a calculated field in my form footer. When I put a second calculated field in the form footer both fields return "#Name?". The 2 fields do not seem to be linked in anyway and I can't for the life of me think why it won't...- Grunster
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Rounding
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...- Grunster
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
How to round to 2 decimal places in a Form
The 3 values are being pulled from 3 seperate tables. The problem has slightly evolved since I posted this is that I have managed to get the percentages to show 3.25% after the calculations have been done. The problem I have now is the with the following figures: I have a Gross amount of...- Grunster
- Post #3
- Forum: Microsoft: Access Forms
-
How to round to 2 decimal places in a Form
Can somebody please help me with this problem. I am doing what I think is a simple calculation of 3 percentages. 3.25% - 0% - 0%. For some reason this seems to keep giving me the result of 3.249999. This then gives me a wrong calculation when using this percentage against a currency amount...- Grunster
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
