Query Criteria

[pbecker13]

I'd like to only show records in my query that either have an address or an email. If both are empty, it shouldn't show up. I don't know how to go about doing it so it tells if one of the two is at least full. I tried Is Not Null And is not null, in the criteria for address, but this did not work.

 

[pbaldy]

I suspect you want OR instead of AND. IOW,

WHERE A Is Not Null OR E Is Not Null.