A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Appending ONLY new records to a table



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2005, 11:37 PM
BillGrubbs
external usenet poster
 
Posts: n/a
Default Appending ONLY new records to a table

I have a database that uses forms to update records in a table. I would like
to preserve historical data, so that the updated record shows up in the form,
but the former (historical) record is still in a table. I believe that an
append query is the best way to do this, but I have had endless problems
getting it to append ONLY the updated records. Each time I update a record,
it tries to append all 216 records, even though only one record has changed.
I have tried assigning the query to an afterupdate event procedure, but it
still tries to append all 216 records, instead of just the updated record. I
have also tried putting both the sourse and recieving tables into the query
and assigning a relationship that specifies all records from the source table
and only those records from the recieving where the records are equal. I
have also tried the reverse of the aforementioned statement. I am using the
following Tables:
Source Table: Nurse
Fields:

Nurse ID(primary key)
LEA
Term
Type
Name
Education
Hire Date
Certification
Salary
License Recieved
License Expiration Date
Date License Recieved

Nurse Hiring History Table(where I want the records appended)

Will have the exact same fields as listed above.

I do not want to have to view a counties entire hiring history in order to
view the current data in the form which updates the source table, but I need
a way of preserving the former employees information automatically when the
form is updated. Again, I do not want to view the old data on a daily basis,
I just need it to be saved in a table for later query, without requiring much
effort on the part of data entry personnel.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending To A Table with Unique Records Stoshu Running & Setting Up Queries 1 February 1st, 2005 06:59 PM
Manual line break spaces on TOC or Table of tables Eric Page Layout 9 October 29th, 2004 04:42 PM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM
Select records Ricoy_Chicago General Discussion 6 July 16th, 2004 07:12 PM


All times are GMT +1. The time now is 12:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.