Query Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few fields in a query that are calculations. The calculations are
being carried out to ten decimal places. Is there a code I can put in the
critera of the design view to have the calculations be carried out to only
two decimal places?
 
I have a few fields in a query that are calculations. The calculations are
being carried out to ten decimal places. Is there a code I can put in the
critera of the design view to have the calculations be carried out to only
two decimal places?
Click to expand...

Not in the criteria (which let you filter or select records based on
the value), but you can wrap the calculated expression in a call to
the built-in function Round:

Result: Round(<some expression>, 2)


John W. Vinson[MVP]
 
Back
Top