Article:
  SQL Subqueries
Subject:   Count the number of record first existing in table at a date
Date:   2007-01-22 08:15:02
From:   nikberry
Response to: Count the number of record first existing in table at a date

Obviously you'd need count() too :).