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.
 
Top