Date Function?

[Guest]

I want a criteria that will return a list of records within a specified
month. The "Month" and the "Datepart" Function don't seem to be working for
me. Any advice?

 

[Arvin Meyer [MVP]]

I want a criteria that will return a list of records within a specified
month. The "Month" and the "Datepart" Function don't seem to be working
for
me. Any advice?

SELECT tblMyData.*
FROM tblMyData
WHERE (((Month([DateField]))=[Enter Month Number]));