Defining Field Types In A Make Table Query

[jo15765]

Is it possible to set what type the fields will be in a make table query? For example, in the source table the fields are autoNumber and memo, in my make table I want the fields to be autoNumber and text. When I run the make table query, it creates both of them as text, is there a way to set what field type?

[orange]

I just tested a make table from an existing table with autonumber, text and number fields. It creates the new table with same datatypes.
I have acc2003 on Vista

If you have a memo and try to make new field as text you may get truncation because of field size limits.
I don't know how you would get autonumber to text by default.

[jo15765]

If you have a memo and try to make new field as text you may get truncation because of field size limits.

Truncation isn't an issue because the l ongest data in that field is 30 characters, and a text field can easily handle that.