J
jez
I have approx 30 000 records. By using select queries i have created an
individual table that contains the information that i require and can
manipulate the data within it to suit my requirements.
At any one time, the table contains a maximum of about 300 records. It is
important that the records are numbered starting at zero.
Each time that i select the required records i run a delete query followed
by an append query to create the new table but can't find a way of reseting
the autonumber to zero as part of the process.
How can i set up a process where on selection of say an area name, delete
the old table contents, add in the new contents and reset the autonumber to
zero, in addition to removing all of the warnings about deletions and
creations?
individual table that contains the information that i require and can
manipulate the data within it to suit my requirements.
At any one time, the table contains a maximum of about 300 records. It is
important that the records are numbered starting at zero.
Each time that i select the required records i run a delete query followed
by an append query to create the new table but can't find a way of reseting
the autonumber to zero as part of the process.
How can i set up a process where on selection of say an area name, delete
the old table contents, add in the new contents and reset the autonumber to
zero, in addition to removing all of the warnings about deletions and
creations?