Setting value to start autonumber field

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Hi,
Can someone please explain how to set the value at
which an autonumber will start? I have two different
tables and in one table I want the primary key (CashSale)
to start at 599, and in the other table I want the
primary key(Invoice) to start at 374.

I tried to use the help within access but it lacks in
detail, it tells me to create a crtieria for this using a
query but I don't have a clue how.

Any help is appreciated.
 
Do a search - this is asked and answered alllllll the time.

Search before you post - it wastes only YOUR time, instead of that of the
people in here posting responses.
 
I did do a search first, but it turns up alot of other
rubbish, and I can only view single messages from search
results not the whole post.
 
Back
Top