setting field size in a make table query

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

Guest

I'm running a make table query that creates a table that must meet a specific
format. This includes field sizes. Not all of the data has to be populated,
but the field sizes must be accurate. I can change the field size in the
original table and it will transfer over through the make table query.
However, some of those fields in the original should remain unchanged. Is
there a function that will allow me to do this? Or, is there a better idea?
 
Create the table first, with the sizes you desire.
Then use an Append query to add the records.
 
Back
Top