If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Year Subtotals
Something is just skipping my mind. All I want to do is set up a report that
details out data by year, then give totals by year. Not one line grand total. See below data and report structure. I know this is probably simple, but I just can't seem to grasp it. Thanks in advance for the help Data: 2000 A 100 2000 B 100 2001 A 100 2001 B 100 Report: A 2000 100 2001 100 B 2000 100 2001 100 Grand Total Wanted 2000 200 2001 200 Grand Total Not Wanted 400 |
#2
|
|||
|
|||
Year Subtotals
Use the Sorting and Grouping feature of the report writer. The first level
should use the field that has the A and B. Set a second level based on the year. Create Group footers for each level. The put the grand totals in the Report Footer. "365Years" wrote: Something is just skipping my mind. All I want to do is set up a report that details out data by year, then give totals by year. Not one line grand total. See below data and report structure. I know this is probably simple, but I just can't seem to grasp it. Thanks in advance for the help Data: 2000 A 100 2000 B 100 2001 A 100 2001 B 100 Report: A 2000 100 2001 100 B 2000 100 2001 100 Grand Total Wanted 2000 200 2001 200 Grand Total Not Wanted 400 |
Thread Tools | |
Display Modes | |
|
|