Precision settings within a query

[Molly]

Is it possible to change the precision settings of a
calculated field in a query. I need to use a price such
as $x.xxxx times 0.6666 and take the result as $x.xx
times a quantity.

 

[Tom Ellison]

Dear Molly:

This sounds like you want to round the results to two places. See the
Round() function in online help.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts