View Single Post
  #1 (permalink)  
Old August 2nd, 2006, 07:24 AM
gherkin gherkin is offline
Registered User
Join Date: Aug 2006
Location: , , United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Append Query issue

Hi all

I have a problem with the above mentioned subject. Basically I have been tasked to create a database of personel records and one of the items that needs to be done is to archive records to another table when that person leaves the company.

After loking around I found out that I should use the append query to push the data to a identical table (just with a different name). However upon creating an apend query it pushes all the data in the main table to the archived one. I only want the particular record i'm viewing to be archived - is this possible, if so would someone be so kind as to put me out of my misery please.:(

Apologies if this seems really basic but I haven't played with Access for years and even then it was more basic databases.

Many thanks in advance