Max for each record

[smpillai11]

Hi,

I have been trying hard to find a way to make a select query in access which gives me the max value for each identity.

I have a table with fields identity (these are not unique in the table) and value:

identity Value

12 --- 1
11 --- 2
12 --- 5
10 --- 3
12 --- 3
13 --- 1
11 --- 1

The select query should give the result:


identity Value

10 --- 3
11 --- 2
12 --- 5
13 --- 1

Someone Pleaaasssee help me

Regards,

Santosh

 

[Krava]

Try select query, then sum (grouping), select both fields, Identity setup=GroupBy, Value setup=Max.

Krava

 

[smpillai11]

Thanks a million !!!!!