Precision settings within a query

M

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.
 
T

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
 
Top