If your data is in the format you describe then you can use a crossTab
query to get the results you desire. Just click on New Query and select
Crosstab from the list. A wizard will come up to guide you through the
query creation process. Select LE for Row Heading, select BS Class for
Column Heading, and select Sum for Amount. You may want to uncheck the
"Include Sum Total" in the lower left corner of the dialog that contains
the list with the Sum function.
*** Sent via Developersdex http://www.yqcomputer.com/