Formatting fields

[Tlewman]

I am having trouble formatting a field in a query. I have a field that is performing a calculation (ex: on hand inventory/last weeks sales) and it brings back my amount with infinite decimal places. I have formatted the fields in all of the tables and other queries that this query feeds from to be a standard format with 2 decimal places but this query is still returning infinite decimal places for this field. I'm sure I have overlooked something simple- what am I missing????

 

[Ziggy]

Did you set the format property of this expression?

Ziggy

 

[Tlewman]

Yes- but it still does not work.

 

[Ziggy]

Try using:

Expr1: Round([on hand inventory]/[last weeks sales],2)

I can't replicate your problem so I don't know the root cause

Ziggy