Experience.FellowshipOne.com

Help.... I've been trying to use the query builder to pull people with a participant attendance record and with an email address.... I keep getting results of folks without emails. I've put in three different requiremnets to get email addresses ex. equal to "listed" type "email" value "@" . Is there something I'm missing??? 

Thanks!

Sharon Sorrentino

FBC
F1 Coordinator

You should be able to put the following in and get what you are looking for:

Search By: Participant Attendance, Field: Activity, Comparison: Equal to, Value: (your ministry) then "add to statement"

Then: Search By: Individual Communication, Field: Type, Comparison: Equal To, Value: Email then "add to statement" make sure that the two statements have "and" in between and then click "Run Search" Make sure you choose the "Run Search" that is *below* your compound statement.

That should give you what you are looking for. I hope it helps!

Lauren