I tried the MAX function on my data table

SELECT TOP 100 MAX(TriageTagNumber) AS [Triage Tag], Location, [Currect Condition], ArrivalTime

FROM ...

I have a similar problem where I have records of individuals that are being tracked as they move through an area. I only what the see the last place...