Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

32 bytes added, 15:51, 8 July 2019
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.
2,299
edits

Navigation menu