June 22, 200718 yr Greetings! Beginner data entry executive assistant here. I have no problem finding all records that have e-mail (in the e-mail field i type ">0"). However, I want to find records that only have e-mail; that is, they have e-mail but not phone numbers. I have no idea how to do this. Any help would be much appreciated. Thanks. -Audra
June 22, 200718 yr 1. go to find mode. 2. Enter "*" in the email field (will find any records that have text in the email field) 3. Enter "=" in the phone field (will find records that phone is empty). Click Find (two search criteria at once narrows the search) Edited June 22, 200718 yr by Guest
Create an account or sign in to comment