Find a record with the highest value

[Lynghaug]

Id (AutoNumber)	User	Item	Registration_Number
1	Tom	This	006
2	Tom	That	001
3	Tom	Other	003
4	Tom	Other	005
5	Tom	This	004
6	Tom	This	002
7	Bob	That	007

What I'd like to retrieve is the latest Registration_Number for each Item that is registrated on Tom.
I got 450 users, so Users can't be a static value.



Pleace help.

[recyan]

Have you tried a aggregate select query with
grouping on
user and item
and
the max of Registration_Number

Thanks

[Lynghaug]

Thanks!
Worked like a charm.
I don't know why I didn't try that earlier. The easiest way.
I thought too complicated.

Again. Thanks.

[recyan]

Glad you got it working.
If I had physically banged my head, as many times as I had overlooked a simple solution, I would have been dead by now.
I still do.

Thanks