Query DOBs for those in a specific Month

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

Guest

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