Make Table Field Definition

[Lambi000]

How can I force a field to be numeric when creating a Make Table query. In
the query I have defined the field to be numeric, standard number, but it
still shows up as a space when I look at the table. Is there some way to
make it default to zero?

This is a problem because the field ends up adding to a numeric field and,
of course, nothing happens.

 

[Allen Browne]

The best solution is to build the query the way you want it, and populate it
with an Append query rather than a Make Table.

If you can't do that for some reason, make sure you give JET all the clues
you can for the intended data type. Do not enclose the number in quotes
(which would give a Text field.) If you need to insert a Null, use IIf() to
give the the alternative, e.g.:
IIf(True, Null, 0)
Of course True is always true, so you will get the null, but JET notices the
type of the alternative.