query by month

[Guest]

How do I run a query by month (as if i need to view everything by a certain
month)

Such as Field1 is my Date Field... How would I write this? I tried
[RADIO DAY] = MonthName (10, OCT)

Yet this returns with a data type mismatch. Can someone help?

 

[Guest]

Nevermind, Problem has been solved, thanks for any time though!

 

[John Spencer]

Field: Month([Radio Day])
Criteria: 10

Of course, you realize this will return records for October of 2005, 2004,
2003, ...