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 ---...