field 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
 
Use 0, not "0". You need to understand the difference numbers and text. "0"
is a text expression while 0 is a numeric expression. I think you can get by
with

Total : Val( Nz([Sum Defects Current Month].[SumOfDefects],0) )
 
Thank you so much, you are great. It is working fine.

Ra


Duane Hookom said:
Use 0, not "0". You need to understand the difference numbers and text. "0"
is a text expression while 0 is a numeric expression. I think you can get by
with

Total : Val( Nz([Sum Defects Current Month].[SumOfDefects],0) )

--
Duane Hookom
Microsoft Access MVP


Ra said:
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
Click to expand...
Click to expand...
 
Back
Top