Currency format

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I have the following equation on a report.
="Total Due From" & " " & [BillableTo] & " $" &(Sum
([Amount]))

How can I drop the "$" and format the [Amount] field to
be currency. Is it something like this?

="Total Due From" & " " & [BillableTo] & " " &
(Format$(Sum([Amount])),"Currency")
 
Andrea said:
I have the following equation on a report.
="Total Due From" & " " & [BillableTo] & " $" &(Sum
([Amount]))

How can I drop the "$" and format the [Amount] field to
be currency. Is it something like this?

="Total Due From" & " " & [BillableTo] & " " &
(Format$(Sum([Amount])),"Currency")
Click to expand...

You have the parenthesis mixed up:

="Total Due From " & [BillableTo] & " " &
Format$(Sum([Amount]),"Currency")
 
Back
Top