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.
|
