field in the table as number

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

field as number 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Make table query: [Enter 1] AS Test 1
specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
dynamic calculated field in query 3
loop with query dates 1
Format query result as Data Type Number, Field Size Decimal 3
Add a field in a query. Easy. . .so I though. 5

Top