Append Queries

[Ann]

I have two append queries that will populate tblMRDF. Prior to appending the
data this tables' records are deleted. The first query adds a header record
that isn't counted numerically. The second append query needs to add all the
records. I need to have a field that will assign the record number after
each deletion of records starting with 1. I can't use the autonumber because
it picks up where it left off.

Thanks in advance for the help.

 

[karl dewey]

The first query adds a header record
This sounds like a spreadsheet because Access tables do not have 'header
resord.'

Why not use a field in your header record that when subtracted from the
autonumber would equal one for your first data record?

 

[Ann]

It is Access. I built the header record myself with an append query. I
tried using a tip I found online to reset the counter each time to one but it
didn't work.

 

[karl dewey]

Try deleting all records, do a Compact & Repair, close database, and re-open.

 

[Ann]

Thank you, that worked. I also found an option under Tools on the General
tab that will "Compact on Close" so I don't have to do this myself each time.

 

[karl dewey]

I have been using "Compact on Close" as 2007 seems to bloat my 2003 database.
I do not find any way to compact except by usin the "Compact on Close".
Is there another way?