Setting value to start autonumber field

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.
 
R

Rick B

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.
 
C

Colin

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Autonumber 0ne-One 25
How to normalize this data 1
2007 Being Weird with AutoNumber 3
AutoNumber vs. Natural Primary Keys 6
Setting an autonumber back to zero 4
Access Many to Many relationship 21
Using 2 Autonumbers in 1 table 2

Top