how to get multiple records byusing subqueries in access database 2007

Mar 19 2010 6:03 AM
SELECT studentdetails.[mobileno] FROM studentdetails where dobirth=(SELECT studentdetails.[dobirth]
FROM studentdetails where month(dobirth)=month(date()) and Day(dobirth)=Day(Date()));


the error is: atmost one record can be returned by a subquery.. when am running in access 2007

Answers (1)