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

On Mon, 29 Jun 2009 09:08:49 -0500, "Boon"
<boonyawat.la-(E-Mail Removed)> wrote:

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


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

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.

"Boon" wrote:

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