Rounding problem

LNewton

Registered User.
Local time
Today, 23:11
Joined
Jan 24, 2002
Messages
31
Is it possible to stop Access from rounding in a select statement or query when grouping by one field and getting a sum in another? I have to compare the summed field in the table #1 with a like field in table #2, compare for any variance, and then prorate back by adding or subtracting any variance found to one of the values in table #1. Access rounds up and therefore changes the value. I have to be exact in the calculation. I would prefer not to change to a text field.:confused:
 
What data type are we talking about integer, single, double or currency?
 
Double, Format = Fixed, Decimal = 3
I am trying to accomplish this in VBA. I can send code if that would Help?
 

Users who are viewing this thread

Back
Top Bottom