Decimals in a query

[cornishteeth]

I know you can set decimal values in a query by going to the field property for the specified field. But what about when the field is an expression? How do you set the decimal value say to 2. It doesn't allow me to set a decimal value like previous. Any suggestions?

Cornish Teeth

 

[dk]

Hi,

You can use the Format function e.g. this will format to 2 d.p.

MyValue: Format([YourFieldName],"Fixed")

 

[cornishteeth]

Thanks! Worked like a charm.....

Cornish Teeth