W
wdsnews
I'm stumped. In a flat file, you can test if the email field is empty. But
suppose your contact info is in a child table? How can I tell if a person
doesn't have an email address? The two tables are People and PhoneComm. In
PhoneComm, the entry is an email when [Contact ID]=5. Here is a query for
finding all the people WITH an email address....
SELECT People.[Last Name], People.[First Name], PhoneComm.PhoneComm AS Email
FROM People INNER JOIN PhoneComm ON People.ID = PhoneComm.[People ID]
WHERE (PhoneComm.[Contact ID])=5
How do I find people WITHOUT an email address?
....thanks for your help.
suppose your contact info is in a child table? How can I tell if a person
doesn't have an email address? The two tables are People and PhoneComm. In
PhoneComm, the entry is an email when [Contact ID]=5. Here is a query for
finding all the people WITH an email address....
SELECT People.[Last Name], People.[First Name], PhoneComm.PhoneComm AS Email
FROM People INNER JOIN PhoneComm ON People.ID = PhoneComm.[People ID]
WHERE (PhoneComm.[Contact ID])=5
How do I find people WITHOUT an email address?
....thanks for your help.