Microsoft Office Tutorials and References
In Depth Information
Creating Reports Automatically
Access displays the first Report Wizard window, shown in Figure 1-2.
can build a
one or more
2. From the Tables/Queries drop-down menu, choose the table or query
that stores the records you want to include in the report.
If you plan to use information from several tables or queries, choose
one of them. The Available Fields box lists the fields in the selected table
3. Select the fields you want to display in the report in the Available
Fields box and add them to the Selected Fields list by clicking
the > button.
Double-clicking a field name also adds it to the Selected Fields list. Click
the >> button to add all the fields.
4. Repeat Steps 2 and 3 for fields in other tables or queries until all
the fields you want to include in the report appear in the Selected
You can use some fields from tables and other fields from queries. For
a customer-order listing, for example, you might select fields from the
Address Book table, the Orders table, and the Order Details Qry
query (which includes the Ext Price field, a calculated field that
equals Price × Qty).
5. Click Next to see the wizard’s next question: How do you want to view
You may want to show the information from the first table on top or
perhaps in some other order.
6. Select the table that you want to organize by and then click Next.
7. Specify any grouping levels that you want to add.