O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

1.
If your Relationships window is still open, close it.
2.
In the Database window, click Queries. Double-click Create Query in Design View.
3.
In the Show Table dialog box, add tblGovernment, tblCountries, and tblHistory (in that order) to the query. Close the Show Table dialog box.
4.
If necessary, maximize the design window. From the Countries field list, double-click the Country, Area, and Population ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required