1
Q
This deck added 4-24-2014
- What if you connect the SUB SUMMARY PART to the ZIP CODE FIELD?
A
they you get PER ZIP CODE totals.
2
Q
- When you add a SUB SUMMARY PART to a REPORT, it acts like a cross between:
A
a TRAILING (or LEADING) GRAND SUMMARY and a BODY PART.
3
Q
- How does the SUB SUMMARY PART behave in a REPORT?
A
It does NOT repeat for every record. but it does repeat: it shows up ONCE for each GROUP OF RECORDS.
4
Q
- Any SUMMARY FIELDS you put on a SUB SUMMARY PART will AUTOMATICALLY:
A
CALCULATE based ONLY on the SUBSET OF RECORDS in question.
5
Q
- Any SUMMARY FIELDS you put in a SUB SUMMARY PART appear in the report:
A
multiple times, so you get multiple SUBTOTALS. In other words, you can put the SAME fields in DIFFERENT PARTS to see different results.
6
Q
- SUB SUMMARY PARTS are unique in TWO WAYS:
A
a. They show up ONLY in PREVIEW MODE.
b. They show up ONLY WHEN DATA is SORTED by the FEILD THEY’RE ASSOCIATED WITH.
