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