Solved Nz in Query Expression - No Currency (1 Viewer)

Weekleyba

Registered User.
Local time
Today, 10:44
Joined
Oct 10, 2013
Messages
586
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.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:44
Joined
Oct 29, 2018
Messages
21,358
Hi. Just curious, although the Format property dropdown may be blank, were you able to simply enter Currency in it?
 

Weekleyba

Registered User.
Local time
Today, 10:44
Joined
Oct 10, 2013
Messages
586
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.
 

vba_php

Forum Troll
Local time
Today, 10:44
Joined
Oct 6, 2019
Messages
2,884
sure thing. guy knows more than me though. he does the job for a living. I don't. =)
 

Weekleyba

Registered User.
Local time
Today, 10:44
Joined
Oct 10, 2013
Messages
586
I know....he's been an awesome help to me many times!
 

Users who are viewing this thread

Top Bottom