Sure. Just add the Round function. AvgSales: Round(Quantity * UnitPrice). If that doesn't work, you might have to feed the results from this query into a second query and do the rounding there. I'd have to test it to be sure, and it's 3am and my brain is starting to shut down. LOL. Give it a shot and let me know.

Richard, thanks for the reply. I actually just went into the query and opened the properties for AvgSales, set the format to currency, and ran the query. Without adding ROUND, it turned it into a rounded currency in the results. On another note, I've noticed that in some queries when selecting a column, under properties and format, there are no choices and the dropdown does not work. Any ideas why? BTW, my brain quits at 10pm.

Be careful with JUST formatting a value as currency. The true value of the field might contain a fraction of a penny which isn't in the display, but still in the value. When you add up all your values it's then wrong. Superman III all over again. ROUND ensures that each value is actually rounded.

If you're dealing with a calculated field in the query, you might not see any options under format. Access doesn't know how to deal with it.

I always liked Richard Pryor, but not sure that was the right role for him. Thanks for the reason to use ROUND.

Oh, Superman III was an awful movie, and no, that was not a good role for Richard. He was a comedy icon and I loved his stand-up, but that movie was just silly. Sup 1 & 2 were good. 3 & 4 were garbage.

Agree Completely! Still, it's interesting the number of people who were inspired by III to try skimming schemes of their own...

Yeah. They even mentioned it in the movie Office Space. LOL