S
Stephanie
Hi. I'm using this sql in my code and it works fine
(thanks to the fabulous list-savers!). But I need to add
another factor and can't get the sytax correct.
I don't want Contacts.EmailName to be null AND I don't
want ChapterMembers.ChapterMemberID to be null. How can I
add that to the sql statement? Thanks, Stephanie
sql = "SELECT Contacts.EmailName FROM ChapterMembers INNER
JOIN " + "Contacts ON ChapterMembers.ContactID =
Contacts.ContactID " + "WHERE ((ChapterMembers.ChapterID)
=" + CStr(Me.FindChapter) + ") AND ((Contacts.EmailName)
Is Not Null);"
(thanks to the fabulous list-savers!). But I need to add
another factor and can't get the sytax correct.
I don't want Contacts.EmailName to be null AND I don't
want ChapterMembers.ChapterMemberID to be null. How can I
add that to the sql statement? Thanks, Stephanie
sql = "SELECT Contacts.EmailName FROM ChapterMembers INNER
JOIN " + "Contacts ON ChapterMembers.ContactID =
Contacts.ContactID " + "WHERE ((ChapterMembers.ChapterID)
=" + CStr(Me.FindChapter) + ") AND ((Contacts.EmailName)
Is Not Null);"