Solved Nz in Query Expression - No Currency

Weekleyba

Registered User.
Local time
Today, 09:05
Joined
Oct 10, 2013
Messages
593
Perhaps an easy question.
I placed the following in a query.
1584734717413.png

I would like the result for this column in the query, to be formatted with Currency.
The problem is, when I use Nz, the Format drop down on the Property Sheet for that column is blanked out.

How can I make this column show Currency. i.e. $100.00 instead of 100.
Also, I still need the Nz so blank entries show up as $0.00.
 
Hi. Just curious, although the Format property dropdown may be blank, were you able to simply enter Currency in it?
 
vba,
I used the following combination that seems to work. Thanks!
1584736374359.png


DBguy,
I can type in "Currency" but it does not change the format.
 
sure thing. guy knows more than me though. he does the job for a living. I don't. =)
 
I know....he's been an awesome help to me many times!
 

Users who are viewing this thread

Back
Top Bottom