Running a query from a previous date

[combine10]

How could I run a query from a physical date from the past? I want to see what the same query looked like a year ago. Is that possible?



Thanks!!

[JoeM]

Only if you are very stringent in how you manage your data.

If you have a field on each record that tracks the date it was added, and you do not edit or delete any existing records, then you could make use of that date stamp field to only include records before a certain date. However, if all three of this conditions are not met, you are probably out of luck, unless you have a backup from the date you want to run it from (then restore that backup somewhere and run your query).

[orange]

Do you have an option in your query to identify the date to use?
If not, you could create a query based on the original to include a date.
I realize it may not be this simple, but you haven't given us much detail to work with.

Perhaps you should have included the query SQL.