Perhaps an easy question.
I placed the following in a query.
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.
I placed the following in a query.
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.