Birthday Query

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

Guest

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....
 
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
 
Thanks so much...I knew it had to be easy!!!!
--
Kelly


Hafeez Esmail said:
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 said:
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....
Click to expand...
Click to expand...
 
Back
Top