# Finding records with missing related records

**URL:** <https://community.spicecrm.io/t/finding-records-with-missing-related-records/212>\
**Category:** KReporter\
**Created:** [November 22, 2017, 8:06am UTC](https://community.spicecrm.io/t/finding-records-with-missing-related-records/212 "2017-11-22T08:06:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![FibreCRM\_Simon](https://avatars.discourse-cdn.com/v4/letter/f/f07891/32.png) [@FibreCRM\_Simon](https://community.spicecrm.io/u/FibreCRM_Simon)\
**Post date:** [November 22, 2017, 8:06am UTC](https://community.spicecrm.io/t/finding-records-with-missing-related-records/212/1 "2017-11-22T08:06:47Z")

</div>

Report: Contacts filtered by missing Email Addresses  
e.g. Which contacts do not have an email address in CRM so that we can start updating/enriching our data

Details  
I have a report listing all Contacts.  
In the Select area I want to select where Contact\>EmailAddress is null  
Because the email address is not stored in the contacts table the report appears to only look at contacts that have an email address record and therefore I cannot list those contacts that do not have an email address.

Is there a way around this issue?  
We are using 4.1 on several CRM systems including SugarCRM CE and SuiteCRM.

---

<div class="post-metadata">

**Author:** ![FibreCRM\_Simon](https://avatars.discourse-cdn.com/v4/letter/f/f07891/32.png) [@FibreCRM\_Simon](https://community.spicecrm.io/u/FibreCRM_Simon)\
**Post date:** [November 22, 2017, 8:55am UTC](https://community.spicecrm.io/t/finding-records-with-missing-related-records/212/2 "2017-11-22T08:55:05Z")

</div>

I figured it out!  
SELECT area  
Email Address field  
Operator = IS NULL  
Required = Optional