dmax function between multiple rows

[Mihir]

I have a quick question.

I am trying the following

This is my table..tStudents

Name Grades
Ram 20
Ram 30
Ram 50
Lakhan 10
Lakhan 10

I am trying to find the range for each Name.. i.e the max and min score
for each Guy.

I did Dmax("Grades","tStudents",[Name])

This gives me the entire range of all the students.. I want range per
student..

Please help!!!!!!!!!

Been stuck on this problem for 3 DAYS!

Thanks a lot!~!!!!

[Mihir]

This is what I am trying..

SELECT DMax("Grade","Table1","Name") AS [Max], Table1.Name,
Table1.Grade
FROM Table1;

[John Welch]

Mihir, try this:

select table1.Name, max([grades]) from Table1 group by table1.Name

but you should rename your "name" field to something else, because "name" is
a special word that is used in several places by Access and it will likely
get confused. So make it something like StudentName.

-John

"Mihir" <mi**********@gmail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...

I have a quick question.

I am trying the following

This is my table..tStudents

Name Grades
Ram 20
Ram 30
Ram 50
Lakhan 10
Lakhan 10

I am trying to find the range for each Name.. i.e the max and min score
for each Guy.

I did Dmax("Grades","tStudents",[Name])

This gives me the entire range of all the students.. I want range per
student..

Please help!!!!!!!!!

Been stuck on this problem for 3 DAYS!

Thanks a lot!~!!!!