How do you set up a make table quert to have a blank row and auto number that
row then assign that row as a primary key?
You can't. MakeTable queries aren't that clever. Create the table
first and use an Append query if you *really* need to do this.
However, MakeTable queries are VERY rarely necessary in practice; why
do you feel that you need to routinely create new tables?
Note also that having a blank and having an Autonumber field are
contradictory requirements. Autonumbers can NEVER be null, so a field
containing an autonumber field will never contain a completely blank
row. Do you mean an additional *field* (for the autonumber) rather
than Row?
John W. Vinson[MVP]
