robertlevine
Registered User.
- Local time
- Today, 04:01
- Joined
- Oct 8, 2003
- Messages
- 24
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
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
