Append Queries

  • Thread starter Thread starter Ann
  • Start date Start date
A

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.
 
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?
 
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.
 
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.
 
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?
 
Back
Top