Currency field in a report

[Guest]

I have a report that strings several fields from a query together to look
like a letter. There is an amount field in the string, but the amount field
will not show in a currency format. I have the field in the table the info
is pulling from set to currency. When I look at the query results, it is in
a currency format. But when I look at the report it is just the numbers from
that field. See below

=[ParagraphText1] & " " & [PcsRec] & " " & [ParagraphText2] & " " & [Amount]
& ". " & [ParagraphText3]

Is there a way to format the field so it shows as a currency instead of a
number?

Thanks,

 

[Rick B]

I don't know the exact format of the statement, but you would do something
like...

=[ParagraphText1] & " " & [PcsRec] & " " & [ParagraphText2] & " " &
Format([Amount],"currency") & ". " & [ParagraphText3]


I'm not sure about the "currency" part. You might use the help feature and
see what the valid parameters are for the "Format" function.

 

[Brendan Reynolds]

=[ParagraphText1] & " " & [PcsRec] & " " & [ParagraphText2] & " " &
Format$([Amount], "Currency") & ". " & [ParagraphText3]