Hello everyone,

 I'm trying to create a query of all constituents who have attended 2 or more events over the last 13 years.   I thought this would be simple enough, and my criteria is "Event Number Attended greater than or equal to 2"  The query pulls these people. However, when I run the query it also seems to be pulling all consituents who only attended one event.  Is there a way for me to filter these people out, or is my criteria completely incorrect?  The query has upwards of 53,000 records (with duplicates) so it will be difficult to manually suppress all of these incorrect constituents.

Any helo would be greatly appreciated--thanks!

Jeff
Reprise Theatre Company
Los Angeles, CA

Event Number attended is a field on the EVENT record and is not a summary field on a CONSTITUENT record.

If you pull up one of yuor events, at the bottom you will notice the calculated statistics for that event:

No. Participants  No. Registered & No. Attended.

So when you are using the criteria "Event Number Attended greater than or equal to 2" in a constituent query you are asking for Constituents that are linked to an event that has 2 or more attendees.

Are you using a Constituent query or a Participant query? Participant is the way to go. You might need to use Export also, to get a clean list without duplicates. I seem to recall when looking at Events in query, you end up getting ALL events they ever attended, unless you only have ONE event in the criteria. Query is not the best tool for event data...

 I was using a Constituent query.  What criteria would I select for a Participant query to get the results I'm looking for?

 Thank you so much, you are so helpful.

Sorry, I misunderstood. I assumed you'd define the events you were looking for...as Laurel pointed out Event Number Attended is how many people attended the event itself. I don't see a way to do this in query. Have you contacted support??

I also think it is not possible to ask the question directly in query.  This type of "number of " question is generally answered in a constituent query under Summary Information and I see no summary for the Event module.  Call BB.  I suspect you will have to export all participants and manipulate the information outside RE.  Maybe a pivot report.

Jeff - I drafted another response to you earlier this morning but apparently it didn't post!? It's not a very elegant solution, but it might get you what you need. I created a constituent query with Event ID not blank and Participant Has Attended = Yes. I added the ConsID & Name in the output fields. Then I went to Reports>Pivot Reports & created a table with Name/ConsID in the row fields, Attended in the column fields & Constituent Count in the details fields. Gave me a nice list of constituents with their totals. You can export to excel & create a query of just those constituents to add additional output fields that you might need. Hope this helps!