max

[slimjen]

All I need help fast please. I am using access 2010. I have a table where I need to pull out the
highest value. But sometimes; there are two or more with the same high value. I
need a way to retreive the first highest value. I've done this before a while


ago and I can't make it work again. I started off with grouping highest value
but are getting all three same values. Please help. Here is an example of what I need:
Thanks

Group   Name     Rate
1            Joe       3
1            Sue           3
1            Jack          2
2    Mary       2
2            Sam          3
2            Sue           3
3            Nan          2
3    Josh      1

Need it to look like this.

Group   Name     Rate
1            Joe       3
2            Sam          3
3            Nan          2

[June7]

Breaking ties can be tricky.

Try this:

SELECT Table1.*, *
FROM table1
WHERE (((Table1.[ID])=DMin("ID","Table1","Group='" & [Group] & "' AND Rate=" & DMax("Rate","Table1","Group='" & [Group] & "'"))));

[slimjen]

ok thanks. I'll try this n post back.

[slimjen]

It worked on my test db! I'll try it at work tomorrow. thanks!