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.
