To add new fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

How can I add new fields in addition to the original fields coming from the
base table using Make Table Query

Clara
 
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.
 
Back
Top