asked on Format the result of a sum field to display as currency
I have text box that read as follows:
=Grand Total"&" "&[Paid]
I need the results to display as Grand Total $15,000.00
=Grand Total"&" "&[Paid]
I need the results to display as Grand Total $15,000.00
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER
I need the dollar sign $ and comma where ever neede.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
How about a label that reads "Grand total" attached to the [paid] field, which is formatted as currency, left justified and has no border showing with a transparent background?
I'm assuming youre doin gthis in either a form or a report - in either case it would work.
I'm assuming youre doin gthis in either a form or a report - in either case it would work.
Example
?Format("12332.33","Curren
$12,332.33
?Format("12332.33","Curren
$12,332.33
="Grand Total"&" "&[Paid]