0uery criteria not working

[JG]

I have a query with the following synatx:

SELECT qryYahrzeitList.YahrzeitDateText, qryYahrzeitList.YahrzeitText,
Format([Date],"mm/dd/yyyy") AS NextYahrzeit, qryYahrzeitList.PARSHA,
Month([NextYahrzeit]) AS Expr1
FROM qryYahrzeitList;

I'm explicitly formatting [YahrzeitText] as a date. I'm then creating
[Expr1] as just having the month value. If I put in a criteria of any number
in Expr1, the query prompt me for [NextYahrzeit]. If I run with no criteria
I get my whole table with Expr1 containing a number 1-12 (correctly). How do
I get Expr1 to recognize a critera?

Thanks.

 

[SoftwareMatters]

Is [Date] an actual field?
If so you shouldn't use it as a fieldname because it is a reserved word and can cause problems so I advise you to change it and then let me know what happens.