Class Inventory Report

CLASS DATE & TIME CAP ENR %SOLD MAX REV REV DIF
Food & Wine I Wednesday, 12/15/2002 6:30 PM 20 18 90% $700 $630 $70
Food & Wine I Wednesday, 12/15/2002 6:30 PM 20 18 90% $700 $630 $70
    40 36 90% $1400 $1260 $140
This report will need to get each row's data from a recordset, as it loops through the records specific variables will be adding up the totals. As the recordset achieves RS.EOF the last row is written using the values of those variables as the totals.
This same format will be used for two different forms: first the analysis here which is all based on a per-class analysis.
The other report will be a by series analysis that will look like this:
SERIES CLASS QTY CAP ENR %SOLD MAX REV REV DIF
Techniques 10 200 180 90% $7000 $6300 $700
Cuisine 10 200 180 90% $7000 $6300 $700
    40 36 90% $14000 $12600 $1400