If the query displays correctly in Access then Good. In Excel you will need to do something like ;
Round (12.55, 1) would return 12.6 (rounds up)
Round (12.65, 1) would return 12.6 (rounds down)
Round (12.75, 1) would return 12.8 (rounds up)
In these cases, the last digit after rounding is always an even number. So, be sure to only use the Round function if this is your desired result.
The syntax for the Round function is:
Round ( expression, [ decimal_places ] )
The Round function can be used in VBA code. For example:
Dim LNumber As Double
LNumber = Round (210.67, 1)
In this example, the variable called LNumber would now contain the value of 210.7.
Like I said, I am not a Excel guy!
Hope this helps.