Without some idea of your table structure, or the SQL statement you have
already created, it will be difficult to offer suggestions other than very
general...
Access queries can be "converted" to "Totals" query, allowing
aggregation/grouping.
--
Good luck
Jeff Boyce
<Access MVP>