Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

107 bytes added, 17:21, 8 July 2019
no edit summary
4. The '''New Report '''page is displayed, with fields for you to fill out.
:: [[File:Reports multiple tables new.png|700px800px|border]]
For this example exercise, fill out the following fields with the corresponding information: 
:** If no match is found, the record from the company is not included in the results.
:** If multiple results are found in the contact table, the company information will be repeated.
:* An '''outer join''' is very different from an inner join. Instead of limiting results to those in both tables, it limits results to those in the "left" company table.
:** 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 BuilderBuilder '''by clicking on the four-square icon above the name of the report:: [[File:Report builder icon.png|border]]
:: 2. Add the '''following fields''':
2,299
edits

Navigation menu