spindar
New member
- Local time
- Today, 06:31
- Joined
- Jan 31, 2003
- Messages
- 8
hello
I have a little problem on a db I am making. I have 2 number fields that I am adding and subtracting to give me a range, both of which have 2 decimal places. Now when I put the results onto a report it lists the results with 8 decimal places.
i.e. 24.10 + 6.30 = 30.40000153 instead of 30.40 as it should be.
How do I stop this happening as it looks ridicculous on the report.
I have a little problem on a db I am making. I have 2 number fields that I am adding and subtracting to give me a range, both of which have 2 decimal places. Now when I put the results onto a report it lists the results with 8 decimal places.
i.e. 24.10 + 6.30 = 30.40000153 instead of 30.40 as it should be.
How do I stop this happening as it looks ridicculous on the report.
