Query Field Format

  • Thread starter Thread starter Grimwadec
  • Start date Start date
G

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
 
Try wrap the expression in Val() which will convert the string value to a
number.
Val(Nz([PriceDefault],0))
 
Back
Top