I have created a query in access that provided results of 5 fields. There are also 2 parameters set on the date field to choose a date range, Between [Start Date] and [End Date].
When I run the query for the first time it works and provides the result set based on the date range.
If I then add records to the database and they are committed. Then run the same query with a date range based on the new records no results are returned.
If I delete the query and rebuild it the same way and run it, the results I entered from the update appear.
I have no filter on the query other than the parameters.
It seems as if the query is caching the results from that first run and I don't know why. Can anyone offer a suggestion as to why this might happen?
Below you will find the sql code from access for the query.
PARAMETERS [Start Date] DateTime, [End Date] DateTime;
SELECT dbo_NonConfData.CaseDate, dbo_NonConfData.Id, dbo_NonConfCreator.CreatorName, dbo_DefectCategory.DefectCatType, dbo_Vendor.Name, dbo_NonConfData.OrderNum
FROM ((dbo_NonConfData INNER JOIN dbo_NonConfCreator ON dbo_NonConfData.Creator = dbo_NonConfCreator.ID) INNER JOIN dbo_Vendor ON dbo_NonConfData.ProducedBy = dbo_Vendor.ID) INNER JOIN dbo_DefectCategory ON dbo_NonConfData.DefectCategory = dbo_DefectCategory.ID
WHERE (((dbo_NonConfData.CaseDate) Between [Start Date] And [End Date]))
ORDER BY dbo_NonConfData.CaseDate;