Microsoft Office Tutorials and References
In Depth Information
Create a Report
Adding, Finding, and Querying Data
Create a Custom Report
1 Open the table for which you want
to create a custom report in Access.
2 Click the Create tab on the Ribbon.
3 Click the Report Wizard button.
The Report Wizard opens.
4 Click the Tables/Queries and
choose the table containing the
fields on which you want to base
5 In the Available Fields list, click a
field that you want to include in the
6 Click the Add button (
The field is added to the Selected
7 Repeat Steps and to add more 6
fields to your report.
8 Click Next .
9 Optionally, click the field you want
to use to group the data.
0 Click the Add button (
A preview of the grouping appears
! Click Next .
Can I choose different fields from
different tables to create a custom report?
Yes. You can choose fields from multiple tables
for your custom report. Simply repeat Step 3
under “Create a Custom Report” to select
additional tables that contain the fields you
want to include. Note that to use fields from
two or more tables, the tables must have a
prior relationship. (To learn more about
table relationships, refer to the tip “What Is
a table relationship?” in the preceding section.)
How do I remove a field from
a custom report?
If you have not yet completed the
wizard, you can remove a field
from the report by clicking the
Back button until you reach the
wizard’s first screen. Then click the
field you want to remove in the
Selected Fields list and click the
Remove button ( ) to remove the field. To remove
all the fields, click the Remove All button (