This is what i used:

SELECT

MAX(ACTIVITIES.StartDateTime) as LastStartDateTime,

ACTIVITIES.CategoryId

FROM Activities

GROUP BY ACTIVITIES.CategoryId

This query gave me the 731 results i wanted,...

That did it.

Wasn't even thinking about MAX()!!!!

That was the missing link.

I knew there was a simple solution.

Thanks a bunch.:-)