setting field size in a make table query

[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?

 

[Allen Browne]

Create the table first, with the sizes you desire.
Then use an Append query to add the records.

 

[Guest]

Thanks,
I think that will work!

Create the table first, with the sizes you desire.
Then use an Append query to add the records.