I will try to explain this the best I can. My data sets have periods (i.e 1-2014, 2-2014, 3-2014)
Each month, I append my table with a new period and then delete the oldest.
I created a macro to do most of the updates but I have not figured out how to either incorporate the delete query into the macro.
I would like to either automate the delete query where some formula could be added into the period field criteria and then the oldest would be deleted automatically (query then easily added to the macro)
OR modify the macro to open the delete query in design, then ask for date criteria (oldest) then once changed, the macro will continue. The delete query has additional queries that need run after this one.