Make Table AutoNumber

[Guest]

Every month I have to run a Make Table Query then modify design and add an
autonumber field for Rank. Is there a way of automating this so the make
table adds the Rank field?

Thanks in advance for any help.
Sue

 

[Jeff Boyce]

Sue

If the fields that get created are always the same, then another approach
would be to create the table design, including your Autonumber (?Primary
key) field. Then, instead of Make Table each month, you'd empty the more
"permanent" table, and append in the new records. The Autonumber field
would take care of itself.

By the way, hoping that an Autonumber field will do what you want ("for
Rank") doesn't mean that's what it was designed to do (provide a unique row
identifier).

 

[Guest]

Thanks Jeff, will try this.

It does work with the rank as autonumber as the make table query puts them
in the correct order first. I know autonumber wasn't really designed for this
use but it works nicely in this case

 

[Guest]

Ah yes of course - it works great with the make table query but when you
don't delete the actual table the autonumber will start from where it left
off... not back at 1 again. Mmmm - will have to look into this more....