Apologies as this will be a bit rushed and no attachment example, but it's quite a straightfoward query (which I've performed before but my mind has gone blank).

I have a file of customer queries dealt with by a particular member of staff from our database. Some of them have multiple entries, if they have been passed to that member of staff more than once. Every time it is allocated to another member of staff, the record is annotated with a sequential 'Log' number. So the first few records read as follows (Enquiry number and log number only)

Enquiry Number log
19 1
19 2
186 5
187 1
187 2
187 3
187 4
187 5
206 1
206 2
206 3

I wish to identify the last time each one was allocated to this member of staff, so I would end up with:

19 2
186 5
187 5
206 3

What's the easiest way?

Thanks