query by month

[Kevin Bruce]

In a select query, I want to pull out all those dates that are in a specific
month regardless of year. How do I write the criteria for that?

Many thanks in advance.

_Kevin

--
================================
Kevin Bruce
Program Coordinator
ArtStarts in Schools
301 - 873 Beatty Street
Vancouver, BC V6B 2M6

ph:604-878-7144 ext.3
fx: 604-683-0501

web: www.artstarts.com

Did you know that you can donate to ArtStarts in Schools directly from our
website? www.artstarts.ca

 

[Wayne Morgan]

Create a calculated field.

MonthOfRecord:Month(

.[DateField])

Set the criteria to 1-12 as desired.

 

[Sunny]

SELECT columns FROM yourtable WHERE MONTH(datefield) = [Enter Month#]