how do I add an autonumber field in a macro?

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

Guest

I haven't used Access for a couple of years. However, I need to chunk a lot
of information fast. I used to use a function in a macro something like this
but forgot what type autonumber is.

ALTER TABLE fglist ADD COLUMN id autonumber

I remember getting it to work when I got the autonumber part to work but
don't remember how I got the autonumber to work.
 
Snorky,

Try...
ALTER TABLE fglist ADD COLUMN id COUNTER

or...
ALTER TABLE fglist ADD COLUMN id AUTOINCREMENT
 
Back
Top