Access '97.
I have a series of nested select queries which ask for a date range. One of the queries doesn't re-ask for the date range but just reports what it once ran.
This means, if I change the desired date range, the results are not as expected.
Any idea how to stop the query persisting with the previously used parameters?
I have a series of nested select queries which ask for a date range. One of the queries doesn't re-ask for the date range but just reports what it once ran.
This means, if I change the desired date range, the results are not as expected.
Any idea how to stop the query persisting with the previously used parameters?