Link to home
Create AccountLog in
Avatar of asarda
asardaFlag for Canada

asked on

Find Max Value MS Access 2003

I am trying to find the max value in the Current column using ms access.
Table
ID    Name    Current
1      A           1
1      B           23
1      C           12  
2      A            22
2      B            9

So my end result with be the following:
ID  Name Current
1    B        23
2    A        22
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

select id, name, max(current) as maxcurrent
from tblname
group by id, name
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account