Make-Table Queries

[millers92]

I am using a make table query to create an archive table of records that are old but still need to be available through the current db. I understand how to create this, but I do not want Access to delete the table that is there everytime I run the make table query. Is there a way I can prevent it from doing so?

Steve

 

[Jack Cowley]

I would not create a new table but add a Yes/No field to the current table and name it Archived. When you want to archive a record just update the Archived field to True. Queries will allow you to see archived or current records.

hth,
Jack

 

[jon98548]

I do something very similar to this in a database of my own. I run an 'append query' to my archive table, so I just keep adding records to it. Am I on the same page with you?

 

[Jack Cowley]

Jon -

I avoid the use of a second table as I do not think that there is any great advantage to doing that and there are some possible problems when moving data. Consequently I just mark a record as Archived and leave it right where it is.

Jack

 

[millers92]

Thanks Jack! That's a great idea. I will give it a run and see if I get the results I need!

Thanks all!

Steve

 

[dblt]

When using Make a query a table is the new table dynamic?

Thanks Jack! That's a great idea. I will give it a run and see if I get the results I need!

Thanks all!

Steve