Append query - Append to table with Autonumber field

B

Boon

Hello,

I have a table named "A". Table "A" has 3 fields, the first field is
Autonumber.

I have 2 queries, first one is the query that delete data in table "A".
Another query will append data into Table A. The second query will append
data into field 2 and field 3. As expected, the field 1 in table "A" is
automatically filled with numbers (autonumber).

The problem is when I run these 2 queries, the number created in table "A"
doesn't start at 1. It seems like it keeps couting from the previous.

How can I make it start it 1 every time I do this? (The field Autonumber is
not mandatory. I can make it as a "NUMBER" field. and use the query that
fills the series when I do the append query. But I don't know how to fill a
series.)

Thanks a lot.
Boon
 
T

Tom van Stiphout

On Mon, 29 Jun 2009 09:08:49 -0500, "Boon"

You will get the desired behavior if you delete the records, then
compact the database, then import the data.
But requiring the autonumber fields to be sequential is rarely a good
idea.

-Tom.
Microsoft Access MVP
 
K

KARL DEWEY

You should not care what the number is as it is not for human consumption.

Acouple of things --
- Compact and repair then close and open the database.
- Append a number that no longer exist.
 

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

Top