Why don't the query properties update?

[RECrerar]

I have a query set up. For many of the fields I have set the decimal place property to 2, but when I vew the query it is still showing all of the digital places, i.e. 12.6783467863 rather than 12.68. Does any one know why this is and how I can sort it out?

I'm using 2003

 

[khawar]

You can use round function like this

Round(Your_Field_Name,2)

 

[DCrake]

Decimal places and the like are for presentation only. If the data was imported, say from Excel, and there was 10 decimal places then this will be imported but Access will only display 2 dec places.

Make sure your source data is rounded to 2 dec places prior to import.

CodeMaster:

 

[RECrerar]

It's the presentation that I'm talking about. I am happy for the data itself to have as many decimal places as it feels like but when I display the data all the decimal places are still visible and I really don't know why. The values are calculated withing the query and the answers to the claculations I want to display with only 2dp

 

[khawar]

When the value is calculated in the query it still displays more than two decimal places when a specific record is selected to get rid of it use round function around your calculation