Formatting Numbers in the Critera

[RachelK]

I have a formula in the critera that goes like this:-

=" Invoiced Amount £" & [Invoiced Amount] & " Less Total Costs £" & Sum([Total Cost]) & " Gross Margin £" & [Invoiced Amount]-Sum([Total Cost]) & " Gross Margin as a % " & ([Invoiced Amount]-Sum([Total Cost]))/[Invoiced Amount]*100 & "%"
The only problem is at the end when I try to work out the percentage the number comes out to 10 decimal places any idea how to make it 00.00. Cheers Rachel.

 

[dhookom]

This would be in a Control Source, not a criteria
You need to use the Format() function to adjust the display of the number. I think you might need to change your expression to something like:
Format(([Invoiced Amount]-Sum([Total Cost]))/[Invoiced Amount]*100 ,"#.00&quot

Duane
MS Access MVP