Email Address No User
Difficulty: Basic
Description: Contacts who have an Email Address but no User Account.
Page: Contacts
Features: Default Field List
Criteria
The criteria can be created easily using the Advanced Search by selecting the three fields and values. Alternatively, you can paste the following criteria into the Filter.
User_Account_Table.[User_ID] IS NULL
AND Contacts.[Email_Address] IS NOT NULL
AND Contacts.[Company] = 0
Field List
This example has cleared the Field List so the defaults are used.