I have a table with names, phone, email. I want to create a report that only includes the records that are empty for phone OR email. I keep just getting an AND option.
Depends on the design of the report.
A simple method is to perform a find where you place an asterisk into both the phone and email fields as your find criteria. The resulting found set, can then be the basis for your report.
Not sure what you mean by:
I keep just getting an AND option.
Are you trying to set up a relationship that matches to all records where both fields are not empty? That isn't normally needed for a report.
I meant records that are NOT empty for phone and email.
Need to proofread better.
That is so easy, sad I missed that.
Thanks so much
Retrieving data ...