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 " & 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