Microsoft Office Tutorials and References
In Depth Information
Creating Reports Automatically
Access gives you a chance to choose how you want to group the data.
For a customer-order report, grouping by customer is a good idea
because it keeps all the information about one customer together.
Within the section for each customer, the secondary grouping is by
order so that all the items in each order are listed together, as shown in
Figure 1-3.
Book V
Chapter 1
As you decide how to group your data, if you realize that you forgot
to include any fields you need, click Back to return to Step 2 and then
add them.
Figure 1-3:
The Report
enables you
to group the
in the
To add another level of grouping, select a field in the list and click the
> button. (You can remove a field by selecting it and clicking the <
button.) After you add a field, you can change the importance (grouping
level) of a field by selecting the field and then clicking the Priority
buttons (up arrow and down arrow).
8. Click the Grouping Options button to customize how records are
Clicking the Grouping Options button (which isn’t always available,
depending on your groupings) displays the Grouping Intervals dialog
box, shown in Figure 1-4, where you can specify exactly how to group
records by using the fields you choose:
• ForDatefields,youcangroupbyday,month,oryear.
• ForNumberfields,youcangroupby10s,50s,100s,500s,1,000s,
5,000s, and 10,000s so that you can categorize values by magnitude.
• ForTextfields,youcangrouponthefirst1,2,3,4,or5characters.
9. Click OK to exit the Grouping Intervals dialog box and return to
the wizard.
Search JabSto ::

Custom Search