Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
how to get multiple records byusing subqueries in access database 2007
radhika ganta
14 years ago
3.1k
Reply
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
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
how to get this in access 2007 as a query
Cannot implicitly convert type 'int' to 'HackerSIMReinvent.DataSet1.UserDataDataTable,Error... This shouldn't happen