adding fields to a table automatically

T

Tomcat

Is it possible to add fields to a table using a query or some way other than
manually inserting a column into the table. These are new fields with no
data and there is no linkage between current fields in the table and new
fields.
 
R

Rick B

Not sure I understand why you would not go into design-view on the table and
add them there. This allows you to define the type, size, format, etc.
 
J

John Vinson

Is it possible to add fields to a table using a query or some way other than
manually inserting a column into the table. These are new fields with no
data and there is no linkage between current fields in the table and new
fields.
Click to expand...

More details please. If there is "no linkage" how will you be able to
fill the new fields? Can you not simply add the new fields in design
view?

It *is* possible to alter a table's design (adding fields along with
other things) using VBA code (adding fields to the Tabledef object),
or - probably a bit more easily - using a DDL (Data Definition
Language) query. Search the online help for "Alter Table'.

John W. Vinson[MVP]
 
Top