Parameter date query displaying incorrect results

[AAA]

I have a query with a calculated field that adds 1 year to a field called [TestDate]. Ex. Date Next Due: DateAdd("yyyy",1,[TestDate]). This works fine. Now I want to generate a parameter based on the calculated field "Date Next Due:". Ex. Between [Enter Start Date:] And [Enter End Date:]. Simple enough, however, the results are incorrect. In my screen captures below I am using a 6/1/15 - 6/30/15 date range. Note that when the query is run without the date parameter the result is 14 records. When it's run with the date parameter it's 11, however, all 6/4/15 records are missing and it added in a 6/1/16 record.

Please help.

Query without parameters:




Query with parameters:

[June7]

How could any records be returned if there are no inputs to the parameter prompts? Very odd that the parameter inputs fail.

I NEVER use dynamic parameterized queries and definitely do not use query popup prompts because cannot validate input. I use VBA to construct filter criteria and pass to form or report.

Post the SQL statement of the parameterized query.

[AAA]

SELECT Meters.[Meter#], Meters.Address, Meters.Size, Meters.City, [Accuracy Tests].TestDate, DateAdd("yyyy",1,[TestDate]) AS [Date Next Due]
FROM Meters INNER JOIN [Accuracy Tests] ON Meters.[Meter#] = [Accuracy Tests].[Meter#]
WHERE (((DateAdd("yyyy",1,[TestDate])) Between [Enter Start Date:] And [Enter End Date:]))
ORDER BY DateAdd("yyyy",1,[TestDate]);

[June7]

Just did a test. The date parameters work on a native field but fail on the calculated field. Seems I've encountered this before. And this works:

WHERE (((DateAdd("yyyy",1,[TestDate])) Between CDate([Enter Start Date:]) And CDate([Enter End Date:])))