http://support.microsoft.com/default.aspx?scid=kb;en-us;225330
OFF2000: New Round Function in Visual Basic for Applications 6.0

When the Round decimal-place argument is zero:
Excel rounds all values of .5 up to the next whole number.

VB rounds odd integers + .5 up
and even integers + .5 down (i.e, 2.5, 4.5, 6.5, etc, would all be rounded
down)

The article tells you how to use Excel's worksheet function within VB code
if you desire the consistency, although not from within a query directly.

This is called Banker's Rounding.  Because .5 is exactly at the middle, if
.5 is rounded up exclusively (or rounded down exclusively), the rouding will
be biased and the total will not be the same as the true total.  In Banker's
Rounding, .5 is rounded to the _nearest_ even (number), e.g. 2.5 to 2 and
3.5 to 4.  In theory, this makes the rounding more unbiased and the total of
the rounded values closer to the total of the actual values.

If you don't want to round this way, introduce a tiny bias to tip the exact
.5 one way or another.

I'm also having trouble with Rounding in Access 2002...

Here's my formula:
Extended Cost:([Mileage]*0.345)+[Cost]

When I run that formula through my query, with Cost = $25 and Mileage = 25,
my Extended Cost displays as $33.63, which is correct.  However, when I click
on that, the screen removes the $ and displays 33.625 ---

So, I modify the formula to include rounding:
Extended Cost:Round(([Mileage]*0.345)+[Cost],2)

Now, my Extended Cost displays as $33.62, which is NOT correct!  When I
click on that figure, the screen removes the $, but RE-displays 33.62 ---

HOW do I get this ROUNDING formula to work?  I want the net result to
display AND store 33.63 ---

Any help from anyone out there would be greatly appreciated.