By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

dmax function between multiple rows

P: n/a
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!~!!!!

Apr 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This is what I am trying..

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

Apr 28 '06 #2

P: n/a
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!~!!!!

Apr 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.