8,849
edits
Changes
→Inner and Outer Joins
:*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]]