4,401
edits
Changes
no edit summary
The company records with no contacts are displayed at the top of the list.
=Locating Null Records=
You can also use this technique to restrict the results to records where there are '''NO''' matching records in the joined table.
By applying the '''Is Null''' expression to the '''Last''' name column, you can display a list of only the companies with no contacts.
1. '''Modify''' the report as shown below:
[[Image:Reps94.png]]
2. '''Build''', '''save''', and '''preview''' the report.
[[Image:Reps93.png]]
You can hide the two columns that are not displaying any date by clicking the '''Show''' check box for these two columns.
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
