Blank Field/Column to table

[Guest]

Hi everybody,

I would like to add a blank Field/Column to a table. The table is built
from other queires. This needs to be done at or near the time the table is
made via a macro.
The reason for the field is that I would like to populate the field later
with manual input data It is not as simple as opening the table in design
view and create the new field. It needs to be there for the user when the
table is created.


Thanks Jones

 

[Van T. Dinh]

Are you using Make-Table Query?

If that is the case, I think you can use, you can add the Field name in the
Select list and add the default value, e.g. an empty String "" in the Values
list.

OTOH, it is *much better* to create the Table structure in DesignView (with
as many Fields as you want and you can control the Field types & sizes,
etc...) and then use an Append Query to insert data to this Table rather
than relying on Access to determin the data types and sizes for you. I
rarely, if at all, use Make-Table Queries in production databases.