Between dates

[cheyenne2002]

I have a table with member birthdates (6/1/1956) and also their spouses. I need to pull out those with birthdays in May and June only.

Any suggestions on how to do this in a simple query. I thought I knew how but my attempts did not work.

I tried doing a Between[Startdate] and [Enddate] but realized that the data has been put in including the year. I even tried using 6/1/1900 and 7/31/2007 to see if it would work, but it gave me everyone.

I also tried sorting thinking I could just copy and paste the ones I wanted, but it sorted them by the year and not the month.

I don't need anything elaborate I just need the data pulled.

Thanks for looking at my problem.
Sharon

 

[Remou]

How about Month.

[tt]Select ID, SName From tblTable Where Month(BDate)=[Enter Month No: ])[/tt]