Query Field Format

[Grimwadec]

I have a field in a query "PriceDefault" which displays e.g. "$50.00".
However when I use Nz in another field "Nz([PriceDefault],0)" the currency
format does not display, e.g. "50". The query field Property Sheet offers
"Format" as one of its properties with no dropdown options and recording
"Currency" has no effect. Help please

 

[Duane Hookom]

Try wrap the expression in Val() which will convert the string value to a
number.
Val(Nz([PriceDefault],0))

 

[Allen Browne]

Try:
IIf([PriceDefault] Is Null, 0, [PriceDefault])

Explanation:
http://allenbrowne.com/QueryPerfIssue.html#Nz