Make Table Question

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have a Make Table Query that I use to make an initial table, the data type
in one filed is TEXT. the Field Size is being set to 2, because the length
I am writing to the field is only 2 place. The problem is I need the field
Size to be larger than 2 when I come back to the table and update it.


Is there a way in the Original Make Table to specify a Text field length
larger than the 2 that it is automatically generating?
 
I hardly ever use Make-Table Queries for this reason.

I normally create a Table structure first to fit my needs and then use an
Append Query to insert Records into the Table.
 
Hi Harold,

Van has given you the *best advice*,
but if you must use a make table query,

in the grid column for "yourfield" of your
make table query, you might try
changing

Field: yourfield
Table: yourtable
Sort:
Show: <checked>
Criteria:
Or:

to

Field: NewFieldName: IIF(True,[yourtable].[yourfield],"")
Table:
Sort:
Show: <checked>
Criteria:
Or:
 
Back
Top