Date query and form

[ysommer]

Hi all
I have a little problem
I wanna make a form that the user can choose from it the month, and it will start a query that will return all the birthdays in that month..
the date in the table is in dd/mm/yy format.

any suggestions?

 

[Imhoteb]

Hi,

First you have to make a query with the datefield in it.
Then create a new field in your query that extracts the month out of the datefield.
It should look like this
myMonth: Month([myDate])
In the criteriafield of myMonth, put the field that contains the month on your form
frmMonth is your form
txtMonth is the field on your form where you put the number of the month in

[Forms]![frmMonth]![txtMonth]

Hope this helps
Good luck