I have this project and it requires the calculation of profit/loss for a company. What they want is to have a certain number of records marked by a code listed on a grid. At the end of those records, they want a summary line item showing the calculation for those items (indicated by a NULL or X to show it is a summary line). Then of course for the process to continue with another group code and it's summary line item.

Now my first thought was to add summary entries into the table which house the group codes. However, it does not work too well that method. I am having trouble seperating the group codes by the summary line. Then I figured on creating a new table to only hold the summary descriptions, but no go there. I could be wrong in the way that I am going about this. Example below:

DESCRIPTION      CODE    AMOUNT

DVD INCOME       410     50000
DVD LOSS         510     10000
GROSS DVD INCOME NULL    40000
VHS INCOME       420     50000
VHS LOSS         520     60000
GROSS VHS INCOME NULL    -10000
ADMINISTRATIVE   610     40000
SALES            710     30000
TOTAL OFFICE     NULL    70000

Any suggestions would be helpful. Thanks!