Birthdays for the month

mikejaytlabustro

Access Database 2007 PH
Local time
Today, 23:02
Joined
Feb 11, 2013
Messages
93
I have [BirthdayField] in a query. How am i going to write the criteria in order to
filter only different dates with the same Month? Thank you guys!
 
You could use the Month function , this returns the number of the month of a date field.

Eg birthdaymonth: Month(Birthdayfield)

Criteria 2

Returns all birthdays in February.

Brian
 

Users who are viewing this thread

Back
Top Bottom