Using multiple formats in single report line

Mike Smith

Registered User.
Local time
Today, 21:00
Joined
Sep 22, 2000
Messages
20
I'm currently using a text box with the control source of

="There are " & Count([AMOUNT]) & " projects funded by the " & [FUNDING_SOURCE] & " valued at " & Sum([AMOUNT])

which works fine but the dollar amount at the end is just a number i.e. 250000

How can I get it to show up as currency without changing any other part of the line?

Thanks
 
="There are " & Count([AMOUNT]) & " projects funded by the " & [FUNDING_SOURCE] & " valued at " & Format(Sum([AMOUNT]),"##,##0.00")
 

Users who are viewing this thread

Back
Top Bottom