I am using Access 2007 on a Windows 7 system.
I am still unclear how to properly us the "Nz" operator.
I have this SQL which provides me with a single record without an
email address. How should I apply the "Nz" function?
SELECT DISTINCT RFEMembers.Email, "Validated Member" AS FullName, 1
AS ReadOnly, 0 AS PostOnly, 0 AS Digest
FROM RFEMembers
WHERE (((RFEMembers.Email) Is Not Null));
UNION SELECT DISTINCT RFEMembers.Email2 AS Email, "Validated Member"
AS FullName, 1 AS ReadOnly, 0 AS PostOnly, 0 AS Digest
FROM RFEMembers
WHERE (((RFEMembers.Email2) Is Not Null));
UNION SELECT DISTINCT RFEMembers.Email3 AS Email, "Validated Member"
AS FullName, 1 AS ReadOnly, 0 AS PostOnly, 0 AS Digest
FROM RFEMembers
WHERE (((RFEMembers.Email2) Is Not Null));
Many thanks,
Robin Chapple
Tidak ada komentar:
Posting Komentar