Look up corellated sub-query. That's what you need to solve your problem.

>I need to count the total number of first occurances of this record.
>
>The records are date, with subsequent records having a greater
>StartDate value. I need to know the total number of first occurance
>records.
>
>

>SELECT SystemKey, UnitID1, StartDate
>	FROM acUnitSystems
>	WHERE StartDate > '2005-12-31'
>	ORDER BY SystemKey, UnitID1, StartDate
>

>
>Thanks