Query DOBs for those in a specific Month

A

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.
 
A

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.
 
Top