decimal places in query

[robert909]

Hi!

I'm using Access 2000 on Windows 2000 and I hope someone can help me with the following question:

In a query I'm selecting field A from a table. Now I would like to have 2 decimal places in the query for field A. Right now it is showing different number of decimal places, depends on how it is entered in the table. So I don't want to do this in the table, but in the query.
Do you know how to do this?

Thanks in advance for your help!

Regards,

Robert
The Netherlands

 

[Rich]

Have you tried setting the decimal places on the field in the query properties sheet?