Originally Posted by
xCav8r
In the meantime, a few questions that might help speed things along...
I assume you mean filter a recordset in a database by date range. Have you already set this up in Excel? If not, is this something that a user can input into a sheet, or does the range need to be obtained in a different way (eg., UserForm, InputBox, etc.)?
Yes filter the record set and the date range can be obtained in any manner. Whether user input into a sheet or any of the other ways mentioned. (I would like a UserForm but it is not imparitive.
This is somewhat confusing for me. Usually filters are saved as queries which are objects of an Access database. Do you perhaps mean to save the results of the query to a new table (in a new or existing database)?
Also, I assume there is a good reason (security/confidentiality/etc) for deleting all records in an old database while creating a new one with a subset of the previously deleted records. I only mention it because it seems a bit odd.