Date criteria on DateAdd calculated query field not working

[tyguy]

This should be really simple but I can't figure it out.. I have a calculated date field in my query using the DateAdd function. I'm using a parameter for this query. When the parameter pops up, and I enter a date, it doesn't return the proper dataset, but rather the entire dataset. Am I missing something really obvious here? I feel like something isn't in the correct format. This is a date field in Access so I'd assume the DateAdd() function preserves that format, correct?

[June7]

I NEVER use dynamic parameterized queries. I prefer: http://www.allenbrowne.com/ser-62.html

I'm not having any luck either. I tried "#" & [Enter date] & "#" as well as CDate() on the DateAdd expression.

[IrogSinta]

I just tried this and had no problem. The dates returned were fine. Can you give a sample of Class_StartDates in your table and the parameter you are entering?

Ron

[June7]

I entered 1/1/2000 and results are not filtered. I know this should work but can't see why it is failing.