I would like Access to query all birthday's for a specific month

[Guest]

Using Access 2002, would like to query a database for birthdays in a specific
month. I already know how to get birthday's based on today's month (+1 or
-1, etc.) but I want to specify which month by entering the month number in a
parameter window.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8def54b303&dg=microsoft.public.access.queries

 

[Allen Browne]

Assuming a table named Table1, with a date-of-birth field named DOB:

SELECT * FROM Table1 WHERE Month([DOB]) = [What month (1-12)];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...