SamIAmOz

Joining latest maintenance record to features

Discussion created by SamIAmOz on Sep 7, 2011
Latest reply on Sep 9, 2011 by dlee-esristaff
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

Outcomes