- Learning How to Create Reports
- The Asia Database
- Begin the Report by Creating a Query
- Beginning a Report in Design View
- Detail Section
- Page Header and Footer
- Using Concatenation
- Report Header and Footer
- Creating a Report Using the Report Wizard
- Comparing the From-Scratch and From-Wizard Reports
- Case Example
This chapter is from the book
Begin the Report by Creating a Query
Usually you'll want to create a report from a query that pulls together data from two or more tables as your record source. You'll create a query that combines key fields from tblCountries, such as area and population, with fields from the other tables that will display the government type and historical legacy.
- If your Relationships window is still open, close it.
- In the Database window, click Queries. Double-click Create Query in Design View.
- In the Show Table dialog box, add tblGovernment, tblCountries, and tblHistory (in that order) to the query. Close the Show Table dialog box.
- If necessary, maximize the design window. From the Countries field list, double-click the Country, Area, and Population fields to add them to the grid.
- From the Government field list, add GovtType to the grid. From the History list, add HistRule (see Figure 10.3).
Figure 10.3 The query in Design view.
- Click the View button at the far left of the toolbar to switch to Print Preview view and view your records.
- Choose File, Save and save the query as qryAdministration.
- Close the query.