Best idea is to create the table the way you want it, and then populate it
with an Append query instead of using a Make Table. If necessary, clear out
the data first with:
DELETE FROM MyTable;
It is possible to specify the extra fields by typing a name and value into
the Field row in query design, e.g.:
MyNumber: 1
or:
MyText: "Something"
If you want to populate these fields with Null, you have the problem of how
you indicate the data type to JET. An Iff() expression will do it, e.g.:
MyNumber: IIF(True, Null, 0)
The first part (True) will never be False, so the 0 will never be assigned,
but it's enough to give JET the clue as to the data type you need.
