Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Total Revenue
- Thread starter kaamchor
- Start date
There is more than one way to get the proper result, but I like the following one:
Use 1 union query:
1. First part: create query for the whole data range with a object that holds constant 'Whole range'
2. Second part: create query for the ranged part with the prompts with additional object that holds constant 'Range'
If you run the report you can now use the additional object as a filter-object or for creating a section-detail report.
T. Blom
Information analyst
tbl@shimano-eu.com
Use 1 union query:
1. First part: create query for the whole data range with a object that holds constant 'Whole range'
2. Second part: create query for the ranged part with the prompts with additional object that holds constant 'Range'
If you run the report you can now use the additional object as a filter-object or for creating a section-detail report.
T. Blom
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question