Select whose birthday is in a certain month

[Frank Situmorang]

Hello,

How can we make a parameter query to know whose birthdays are in March for
example. What is the VBA in the form query. In this forum it is explain to
filter from start date and end date, but what we need is to select birthday
by month.

Thanks in advance

 

[Arvin Meyer [MVP]]

See the following sample database:

http://www.datastrat.com/Download/Birthday2K.zip

 

[Frank Situmorang]

thank you Arvin for quick response. Since the users will be some secretaries
in our church, so I just want to make it easy using option group. So I want
to make them only click for example Birthday of Jan. Feb. Mar......

What is the VBA of the option grourp choosing from Birthdate field of
church member table.

Thank you,

 

[John W. Vinson]

thank you Arvin for quick response. Since the users will be some secretaries
in our church, so I just want to make it easy using option group. So I want
to make them only click for example Birthday of Jan. Feb. Mar......

What is the VBA of the option grourp choosing from Birthdate field of
church member table.

Thank you,

Create an Option Group with labels Jan, Feb, Mar etc., with corresponding
values 1, 2, 3 - the month number.

Use a Query with a calculated field

BirthMonth: Month([birthdate])

and use a criterion on the field of

=Forms!YourFormName!YourOptionGroupName

John W. Vinson [MVP]