Specifying the number of decimals in a query output

[accessaspire219]

I was wondering if it's posible to specify the number of decimal places in a select query output?? I am currently getting 5 decimal places and I need only 2.

 

[pbaldy]

You can use the Round() function.

 

[accessaspire219]

great!! so would it just be round([column_name],2)?? in the field for criteria??
Thanks!!

 

[pbaldy]

I would think you'd want that as a field, not the criteria.

 

[accessaspire219]

Yes, got it. It's working.
Thanks!!