Append query - Append to table with Autonumber field

[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

 

[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

 

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