Make Table Query

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

Guest

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?


Thanks,
Corby
Salt Lake City, UT
 
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?
Click to expand...

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]
 
Back
Top