Show Birthdays for a particular month

[Guest]

I have read many of the threads in the anniversary sections, but I am only
learning, so can I ask a dumb question ?

Can I retrieve birthdays for a particular month just in the criteria of a
query or do I need to use SQL ?

Question sample: Everyone who's "Birthdate" is in August ? format is
dd/mm/yyyy.

I want to be able to run this for any month.

Thanks and my apologies for my lack of knowledge

 

[Allen Browne]

Create a query into the table that has the BirthDate field.

Drag the fields into the grid that you wish to see (e.g. name and
birthdate).

In a fresh column in the Field row, enter:
TheMonth: Month([BirthDate])

In the Criteria row beneath this, enter:
[Which Month Number?]

When you run the query, Access will pop up a box where you enter a number
between 1 and 12 for the month. The query then shows the birthdays in that
month.

 

[Marshall Barton]

I have read many of the threads in the anniversary sections, but I am only
learning, so can I ask a dumb question ?

Can I retrieve birthdays for a particular month just in the criteria of a
query or do I need to use SQL ?

Question sample: Everyone who's "Birthdate" is in August ? format is
dd/mm/yyyy.

I want to be able to run this for any month.

The quick and dirty way is to use a calculated column in the
query:

BirthMonth: Month(birthdayfield)

and add the criteriaL

[Enter Month Number]