Auto number field in query

[Guest]

How do I create a autonumber field in a make table query.

 

[John Vinson]

How do I create a autonumber field in a make table query.

You can't.

Create the table, empty, in the Tables window, and run an Append query
to populate it.

Note that MakeTable queries are VERY rarely really necessary; in a
properly normalized database there will already be a table for each
Entity represented by your database. If you're creating a table on the
assumption that you need a new table every time you have a new set of
data to report (or export), reconsider that assumption; it's easier to
base Forms, Reports, and file exports on a Select query than it is to
change the exact same select query into a MakeTable query.

John W. Vinson[MVP]