7/20/2008 5:07:33 PM
Access Tip: Birthdays in July
By Richard Rost
Q: I need to make a query to find all customers who have birthdays in July. How can I do that?
A: You can easily do this with the DatePart function. Just create a query, and in that query make a new CALCULATED FIELD such as this:
Where DOB is the date of birth field from your table, "m" represents the month, and MyMonth is going to be a new field which should be a number from 1 to 12.
Now, just set the Criteria for that field (in the same column) equal to whatever month you're looking for. For July, that's 7.
Piece of cake.
Keywords: access tips birthday datepart