Basically you do with a query, either Maketable or Append Query.
As the name suggests a Make Table query creates a table with data you have selected. An Append query appends records you have selected to another table. In your case you would have a thrird query called a Delete query which deletes the records selected (or all the records) from the table in question.
A macro simply runs the queries in the appropriate order.
How you do this sort thing dpends on want you want as an end result. For example, in the table you want data to be stored each month would you want a situation which would would tell you when it was done and what data was stored at that time.
Another way (and usually the preferred way) is the data is left in the table but a query does not display the data, perhaps because of dates or whatever.
In a nutshell you need is a basic knowledge on making what are only simple queries and the whole thing is easy.
