Dynamic reports update only the data that is changed or added
to a table or query. It does not show any modifications made to
a table or query. For example, open the fuel economy query you
just created. For the "End-Reading".”Odometer –
Fuel.”Odometer” column, change the number 1 to the number 3
after creating the report below. The report will be identical
before and after you make the change.
For example, a report on vacation expenses divided into categories
should probably be a static report because it is based upon specific
data that does not change. However, a report on the fuel data should
probably be a dynamic report, because this report depends upon data
that does change.
All reports are based upon a single table or query. So you
need first to decide what fields you want to use in the report.
If you want to use fields from different tables, you must first
combine these fields in a single query. Then you can create a
report on this query.
An example of this caution is creating a report on vacation expenses.
Fuel costs are one part of that report as are meal costs. These values
are contained in fields of two different tables: Vacations and Fuel. So
this report requires creating a query.
Creating a static report
We will create a report on vacation expenses. Certain questions need
to be asked before creating the report.
What information do we want in the report?
How do we want the information arraigned?
What fields are required to provide this information?
Will a query have to be created because these fields are in
Are there any calculations required in the data before being
added to the report?
The expenses for our vacation are motel, tolls, miscellaneous,
breakfast, lunch, supper, snacks, and fuel. One possible report would
simply list the totals of each of these expense groups. Another possible
report would list the expense totals for each day of the vacation. A
third possible report would list the totals for each expense group for
each type of payment. (This would let us know where the money came
Chapter 8 Getting Started with