make-table query

[Elsie]

hi, how can I change the field size for 1 of the fields in a table which is
made by a query? the output of the field always gives a field size of 16,
but I need it to be 30 at least.

 

[Allen Browne]

Create the table with the fields as you wish, and then use an Append query
to add the records instead of a Make Table query.