Query DOBs for those in a specific Month

[Amanda]

Hello,
I have a column in a table for Date of Birth ( DD-MM-YY).
Is there a way to have a user inout a month and query for the birthdays
within that month?

Thanks.

 

[Arvin Meyer [MVP]]

Sure a query like:

SELECT tblMyData.*, Month([DateField]) AS Expr1
FROM tblMyData
WHERE (((Month([DateField]))=[Forms]![MyForm]![MyTextBox]));

The user will enter a month number in your form (MyForm) and the query
above, or form based upon that query will show only those dates.