2,299
edits
Changes
no edit summary
{{Banner-UnderConstruction}}
In this article, you will create one of the most useful reporting features – the ability to relate the information from two tables into a single report.
:: {{Icon-Menu}}
2. Under the tab '''Tools, '''select '''Reports. '''
:: [[File:New report pag.png|700px|border]]
For this example exercise, fill out the following fields with the corresponding information:
:: [[File:Recordsets tab.png|750px|border]]
3. Scroll to the '''Table''' list.
:* This means that if there are no records in the contact table, a row in the report will still be returned for that company, but with NULL values for each column from contact.
1. Open the '''Report Builder'''.
: 2. Add the '''following fields''':
: [[Image:Reps98.png]]
:* The '''Field''' list now contains fields from both tables.
3. '''Build''', '''save''', and '''preview''' the report.
: [[Image:Reps97.png]]
:* The company name, city, and state information is displayed from the company table for each matching record from the contact table.