Birthday Query

[Kelly]

I have a birthday field called 'Birthdate', it is formatted as mm/dd/yy. I
need create a query that asks for just the month....

 

[Hafeez Esmail]

Create your query, and in a new column in the design grid view, enter the
following:
Field: Month: Month([birthdate])
Criteria: [Please enter a month:]

as long as you type in the month number (i.e. october = 10 and feb = 2),
you'll be able to see every record (despite the year or date) that is in the
month you've entered.

HTH
Hafeez Esmail

 

[Kelly]

Thanks so much...I knew it had to be easy!!!!
--
Kelly

Create your query, and in a new column in the design grid view, enter the
following:
Field: Month: Month([birthdate])
Criteria: [Please enter a month:]

as long as you type in the month number (i.e. october = 10 and feb = 2),
you'll be able to see every record (despite the year or date) that is in the
month you've entered.

HTH
Hafeez Esmail

I have a birthday field called 'Birthdate', it is formatted as mm/dd/yy. I
need create a query that asks for just the month....