How to Format results for report?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a report with the following expression in a text box for tax,

=Sum([SubtotalLow]) & " @ 13.5% " & Round(Sum([TotalVatLow]),2)

I get the intended result, but how do I format this to display the result as
standard number, ie. to display trailing zeros (59.3 as 59.30)

Thanks for any help

John
 
I have a report with the following expression in a text box for tax,

=Sum([SubtotalLow]) & " @ 13.5% " & Round(Sum([TotalVatLow]),2)

I get the intended result, but how do I format this to display the result as
standard number, ie. to display trailing zeros (59.3 as 59.30)

Thanks for any help

John
Click to expand...

Use the Format() function:

Format(Round(Sum([TotalVatLow]),2),"#.00")

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top