field in the table as number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a make table query. One of the fields has the following expression:

“Total : IIf(Nz([Sum Defects Current Month].[SumOfDefects])=" ","0",([Sum
Defects Current Month].[SumOfDefects]))â€.
I set up the field parameter in the query to a general number.

However after making the table I get the field in the new table as text.
Please advise on how to get the field in the table as number, not text.

Thank you,

Ra
 
is your source field a number or text? try taking the quotes away from
around the "0". quotes turn numbers into text strings.
Agr
 
Back
Top