Hi,
I'm trying to join the latest maintenance record to a feature through a common FacilityID. I thought I'd simply summarize the maintenance records on FacilityID, taking the latest date, then I loose the appropriate maintenance data. How select the most recent row for a given FacilityID?
Seems like an easy task. What am I missing? Any help appreciated.
Cheers
Sam