Query using dates

[Guest_imported]

I want to report all the records whose Birthdate field(dd/mm/yyyy) is the same month as enterd in the Query parameter.

ie if I enter July then I should get all the birthdays which are recorded as being in July ie (dd/07/yyyy).

How do i do this ?

 

[tlbroadbent]

This is a duplicate post (see thread701-105142). Please post a question only once. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin