field in the table as number

R

Ra

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
 
A

agr1259

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