Display as currency

L

lmossolle

I am using the following coding, could someone assist in format for currency?

Sum(Nz([PR $ Value])) AS [$ Value]

Thanks
 
M

Marshall Barton

lmossolle said:
I am using the following coding, could someone assist in format for currency?

Sum(Nz([PR $ Value])) AS [$ Value]
Click to expand...


Set the text box's Format property to Currency.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto copying text 0
Mail Merge - displaying a conditional number of decimals 5
Concatenate, currency & sum formula 2
Currency format with 2 decimals not showing on report 2
Formatting currency within a report text box expression 1
Excel Formula 1
VBA Coding Help for Beginner 0
Currency formatting (Issue with globalization/localization) 1

Top