4,401
edits
Changes
no edit summary
In this article you will modify the query to display companies where there are no contacts.
1. Change the '''join type''' on the '''Contact''' table to '''Outer Join'''.
[[Image:Reps96.png]]
2. Open the '''Query Builder'''.
3. Change the '''Sort''' order for the '''Last''' name field to display the records in '''descending''' sequence.
4. '''Build''', '''save''', and '''preview''' the report.
[[Image:Reps95.png]]
The company records with no contacts are displayed at the top of the list.
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
1. Change the '''join type''' on the '''Contact''' table to '''Outer Join'''.
[[Image:Reps96.png]]
2. Open the '''Query Builder'''.
3. Change the '''Sort''' order for the '''Last''' name field to display the records in '''descending''' sequence.
4. '''Build''', '''save''', and '''preview''' the report.
[[Image:Reps95.png]]
The company records with no contacts are displayed at the top of the list.
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
