Create Numeric query fields in MAKE table

[jnh]

Hi,
Have a Make table query that needs to create (add) several new fields where each field must be numeric design.
Have tried:
Score1: Not Null - does not seem to work (results in a Binary field)
Score1: 0 - which does give me the numeric field designation but every field in table contains a 0.
Would like to show Blank field (makes data input easier at a later time) but still have the Numeric designation. Thanks for any directions you can point me to...jnh

 

[bob fitz]

Can you show us your SQL statement.

 

[jnh]

It is just a simple Make table query:

Score1: 0 Where Score1 is a NEW field

Using above I get a numeric field in my new table but value is preset to 0.

 

[bob fitz]

And the SQL is?

 

[jnh]

NOT a SQL - just a simple make table query with several fields taken from another table and new fields (Not found anywhere else) added via:
Score1: 0
or Score2: 0*1
and so on.

Given above example the Score1 (and Score2) field in new table will be numeric type but table shows a 0 in every field (which I would like to default to a Blank)...jnh

 

[bob fitz]

NOT a SQL - just a simple make table query with several fields taken from another table and new fields (Not found anywhere else) added via:
Score1: 0
or Score2: 0*1
and so on.

Given above example the Score1 (and Score2) field in new table will be numeric type but table shows a 0 in every field (which I would like to default to a Blank)...jnh

If it is a query, then it has an SQL statement.

 

[jnh]

Trust this is what are you looking for....

SELECT Left([2014 Spring Tournament],1) AS PlayType, [tbl_2014 Roster].[Last Name], [tbl_2014 Roster].[First Name], 0 AS [Game 1], 0*1 AS [Game 2], 0*1 AS [Game 3], 0*1 AS [Game 4] INTO [tbl_Tournament Enter Score]
FROM [tbl_2014 Roster]
WHERE ((([tbl_2014 Roster].[2014 Spring Tournament]) Is Not Null And ([tbl_2014 Roster].[2014 Spring Tournament])<>" "))
ORDER BY Left([2014 Spring Tournament],1), [tbl_2014 Roster].[Last Name], [tbl_2014 Roster].[First Name] DESC;