GaelicFatboy
Registered User.
- Local time
- Today, 19:18
- Joined
- Apr 17, 2007
- Messages
- 100
Hi everyone,
I’m trying to construct a query for a report that calculates the internal volume of pipes in litres accurate to two decimal places, but when I view the query the volumes come back with 13 or so decimal places. I’m using a function to calculate the internal volume like so.
InternalVolume = Round(((Mysgl_Length * 0.25 * Pi * (Mysgl_ID / 1000) ^ 2) * 1000), 2)
I’ve set the field to a general number with two decimal places and even used the “Round” function within the query. The question is why won’t the numbers round down to the number of places I’m specifying?
Cheers
D
I’m trying to construct a query for a report that calculates the internal volume of pipes in litres accurate to two decimal places, but when I view the query the volumes come back with 13 or so decimal places. I’m using a function to calculate the internal volume like so.
InternalVolume = Round(((Mysgl_Length * 0.25 * Pi * (Mysgl_ID / 1000) ^ 2) * 1000), 2)
I’ve set the field to a general number with two decimal places and even used the “Round” function within the query. The question is why won’t the numbers round down to the number of places I’m specifying?
Cheers
D