Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Historical Records

Status
Not open for further replies.
gal4y

gal4y

Technical User
Dec 24, 2001
72
US
Is there any way to take records from two tables and make historical records from them.

I have tried the append and delete queries but the table has duplicates after two rounds.

Is there an easy way to do this.


Thank you in advance
Greg
 
Sort by date Sort by votes
use update query instead of append

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
404
dhookom
dhookom
blueman124
  • Locked
  • Question
All records not showing in access table that is linked to sharepoint list
Replies
0
Views
332
blueman124
blueman124
Moss100
  • Locked
  • Question
Turn one to many relationship into single records 2
2
Replies
34
Views
1K
Moss100
Moss100
bobjackson
  • Locked
  • Question
Selected records write to table with field based on percentage of selected records
Replies
5
Views
315
bobjackson
bobjackson

Part and Inventory Search

Sponsor

Back
Top