query by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Field: Month([Radio Day])
Criteria: 10

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