Query to return 2 decimal points

[douggy]

hi there,

how can I alter this query to force two decimal points in the resultant figure.

Margin: IIf([Margin Value]>0,[Margin Value]/[Sales Value],0)

I can do it by setting the field property in the query designer, however I want to force it in the query.

Is this possible.

Thanks
Mark

 

[lespaul]

yes, it's the FORMAT function, but I don't have Access on this PC so I can't remember the exact formula!

Leslie

Come join me at New Mexico Linux Fest!

 

[dhookom]

I don't normally format in a query. This should generally be performed in the control on your form/report that displays the value.
Try:

Margin: Format(IIf([Margin Value]>0,[Margin Value]/[Sales Value],0),"0.00")

The result will be a text value rather than numeric.

Duane
Hook'D on Access
MS Access MVP