Query Criteria

[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?

 

[John Vinson]

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?

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]