Hi,

I'm trying to create a report in Access 97 that has a number of subtotals, but only for specific data. Other data in the report doesn't need subtotals.

I have attached a .txt file (format.txt) that shows the type of layout I'd like.
I have also attached the data that I have in the table (pldata.txt)

Now I have all of the necessary data stored in a table in the following format:
Type | Daily | MTD | YTD
(type is the left-most column which tells the data type)

Now, the lines that say Total [something] are the lines that I need to subtotal. For instance, "Total Index Futures" = "Index Futures" + "Fair Value Adjustment"

"Total Revenue" = All values above that line (not double counting the subtotals)

I need help badly :)

Please...can anyone help? I can supply more info if need be!

thanks in advance.