Database Reference
In-Depth Information
Creating reports manually
When a report includes controls that are bound to specific fields in one or more tables,
usually the most efficient way to create the report is by using the Report wizard. When you
include more than one table in a report, the wizard evaluates the relationships between the
tables and offers to group the records in any logical manner available. As with multitable
forms, if you haven't already established the relationships between the tables, you have to
cancel the wizard and establish them before continuing.
TIP If you are using more than two tables in a report, or if you will be using the same com-
bination of tables in several reports or forms, you can save time by creating a query based
on those tables and then using the results of that query as the basis for the report or form.
For information about queries, see Chapter 7, “Create queries.”
When a report will include mostly unbound controls, which don't pull information from
underlying tables, it is easier to create the report manually in Design view. In this view, the
structure of the report is laid out on a design grid, in much the same arrangement as a form
in Design view.
Reports have five main sections and can include additional grouping sections.
Search WWH ::




Custom Search