Would I use a query or what

[trackmedic]

I have a database that has 8000 entries in it. I want to strip the material out of it at the end of the quarter and save it somewhere.

I could basically make a copy of the whole database and strip the original down.

What i would like to do is have some type of query where I basically hit a button and it happens automatically. but, if I need the info back, I could hit another button and the stuff would magically appear. Can this happen?

Thanks to all the access gurus!

 

[pbaldy]

You can do it (append and delete queries), but the real question is why? Access can handle far more data, and it's rarely necessary to archive off data. If you leave it, you can still query against it to get yearly data, etc.

 

[Mike375]

You can do it (append and delete queries),

But make sure you run the two queries from code or a macro so you don't get 'em out of order

 

[ajetrumpet]

Would I use a Query or What

I would use a what instead of a query myself...