Distinct, Most Recent Sort

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Does anyone know how to do a sort to find the most recent distinct records.

We have records with equipment, and activities the equipment was used for,
but I need a distinct list of where the equipment currently is, if I do a
distinct ...order by date, it will perform the distinct first, ahead of

Thanks for your help.

Site Timeline