Query for Label where field is null

[JoeM]

By blank, do you mean that there is a space in there?
If so, just use the TRIM function to drop any trailing spaces, i.e.

SELECT DONORS.ACCTID, DONORS.TITLE, DONORS.FNAME, DONORS.LNAME, DONORS.ADDR1, DONORS.CITY, DONORS.STATE, DONORS.ZIP, DONORS.COUNTRY, DONORS.SUPPORT1, DONORS.EMAIL1, DONORS.EMAIL2
FROM DONORS
WHERE (((DONORS.SUPPORT1)="X") AND (LEN(TRIM(DONORS.EMAIL1) & "X")=1) AND (LEN(TRIM(DONORS.EMAIL2) & "X")=1)
ORDER BY DONORS.ACCTID;

[cshipley83]

The field is empty.

Basically I need the mailing labels to pull for a specific person (Support1) where the address (ADDR1) is not empty and email addresses (EMAIL1 and EMAIL2) are empty.

[JoeM]

Just use similar logic like we have already incorporated:

WHERE (((DONORS.SUPPORT1)="X") AND (LEN(TRIM(DONORS.ADDR1) & "X")>1) AND (LEN(TRIM(DONORS.EMAIL1) & "X")=1) AND (LEN(TRIM(DONORS.EMAIL2) & "X")=1)

[cshipley83]

Thank you.