Setting value to start autonumber field

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.



"Colin" wrote in message
...
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.

See:
Set AutoNumbers to start from ...
at:
http://members.iinet.net.au/~allenbrowne/ser-26.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Colin" wrote in message
...

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.

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.

-----Original Message-----
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.



"Colin" wrote in
message
...
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.


.