Archive data or History table 1

[Greg553]

I have a table called tbl_weightlifting
It has hundreds of records of players on there weight lifting.Fields are
What I want to do is be able to save this table as a history table, meaning as players leave and new ones come in I want to have a records table that will hold all the history.
At the same time I want to delete the Player records from the current table as they graduate.

i know I can use a query but not sure how to do this.

This way they archived history table still holds all time records, but they new table only
reflects current athletes

the table is set up like this

Weight_ID ( auto #)
Player_ID
Lift_ID
Weight LIfted
Date
Program_ID ( what program they were using)

 

[randy700]

The easiest and, in my opinion, best way would be to add one more field to your current table. Something like Player_Status. This way all the data is still contained within a single table. Update current queries with a WHERE clause that excludes players with a Retired status.

If you really want another table, copy your current table (structure only). Use an append query to move entries from one table to the other followed by a delete query to remove the data from the original table.


Randy

 

[Greg553]

Thanks, I will try out your idea,