I am trying to make a report where user inputs a month number, and report shows the names of all people that have their birthdate in that month including their name.

I have table contacts, which have a field called name and DOB .

my DOB is stored day,month,year, 31-5-2005.

Have a look at the datepart function.