Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Need Query Help...

Author  Topic  Neo Starting Member 1 Post Posted - 2009-08-20 : 08:00:32 Hello Everyone, I have created two tables in my MSAccess Database. Students [Roll_no, Name, Address, Phone, Semester] Marks [Roll_no, Sub1, Sub2, Sub3, Total, Percentage, Result] First table content all the students names with their semesters and second table contents their marks they have achived in their exam. Now I have many queries but two queries that i couldn't make out and they are : 1. Find the Student Information who stood first in their purticular Semester. 2. Find the student name who achieved first in all subjects in their particular semester. >>>>> NIC <<<<<