run an append query on a selected record

G

Guest

I have a database that periodically I need to archive the records from the
main table to an archive table. I run an append query to copy all the
records from the main table to the archive table. Then I run a delete query
to remove the records from the main table. There are times when I would like
to return a selected record from the archive table back to the main table. I
have created an append query to do this, but it wants to append all the
records back to the main table. How do I only append the selected or current
record?
 
S

Steve Schapel

ET,

You have to apply a Criteria in the query that will restrict to the
required record. So that begs the question... how do you identify the
required record? You mean the current record on the form? And the
record has an ID field of some sort to uniquely identify each record?
If so, in design view of the append query, in the Criteria of the ID
field, you would put the equivalent of...
[Forms]![NameOfForm]![ID]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Append Query question - Is this scenario possible? 1
Append Query is not working 1
append query 1
append query and delet query 7
Access 2010 append query to SQL is very slow 0
Exicute an append query in an after update event 0
Append and Delete in one step 3

Top