If you remained consistent with marking the journal contact you created, you will be able to query on those who attended, those who accepted the invite but did not attend, and those who were invited but a RSVP was never received.

Before the event, you can see how many people have RSVP'd with the below query.
  1. Click Queries
  2. Click the Event Queries category
  3. Click New Query
  4. Name the query: RSVP
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching select Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Journal Entry Date
  10. Fill in the date of the event
  11. Choose Defined Fields from the Browse Fields drop down box
  12. Click Contact Method
  13. Choose Event Accepted
  14. Click Save and Preview

After your event is held, if you wish to see those who attended the event, you would create the above query, but select Event Attended instead of Event Accepted.
  1. Click Queries
  2. Click the Event Queries category
  3. Click New Query
  4. Name the query: Attended
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Journal Entry Date
  10. Fill in the date of the event
  11. Choose Defined Fields from the Browse Fields drop down box
  12. Click Contact Method
  13. Choose Event Attended
  14. Click Save and Preview

If you wish to see those who did not respond with a RSVP, select Event Invited instead of Event Accepted.
  1. Click Queries
  2. Click the Event Queries category
  3. Click New Query
  4. Name the query: Did not RSVP
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Journal Entry Date
  10. Type in the date of the event
  11. Choose Defined Fields from the Browse Fields drop down box
  12. Click Contact Method
  13. Choose Event Invited
  14. Click Save and Preview

If you wish to see who sent a RSVP, but did not attend, you can run the same initial query (RSVP). This query would pull different results after your event, because those that attended would have a new method entered at this time.

If you wish to see everyone who was invited regardless of whether they ever accepted or attended, you will simply choose UDFs - Contacts under Available fields, choose Event Name, and then select the appropriate event.
  1. Click Queries
  2. Click the Event Queries category
  3. Click New Query
  4. Name the query: Invited
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose UDFs - Contacts from the Browse Fields drop down box
  9. Click Event Name
  10. Choose the Event you want
  11. Click Save and Preview
Here are steps for a report that would give you the name and address for all those above scenarios.
  1. Select Reports in the menu bar and select the category you want to store this report under
  2. Select New Report under the Tasks Menu
  3. Name the report
  4. Choose Sets from the Report Columns drop down box
  5. Click Name and Address
  6. Select Save and Run under the Task Menu
  7. Choose your category and query
  8. At the bottom of the page choose a Delivery Option from the report format drop down box and then click Submit
You can also find all accounts that have been assigned a table number.
  1. Select Queries in the menu bar
  2. Select Event Queries
  3. Select New Query under the tasks menu
  4. Name the query Table Assignments
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Journal Entry Date
  10. Fill in the date of the event
  11. Choose UDFs - Contact from the Browse Fields drop down menu
  12. Click Table Number
  13. Select field has any value
  14. Click Save and Preview

Here is a report to display more information about your table assignments.
  1. Select Reports in the menu bar
  2. Select the category you want to store this report under
  3. Select New Report under the Tasks Menu
  4. Name the report
  5. For Report Columns choose Commonly Used Fields from the Browse Fields drop down box and click Name, Date
  6. Select User Defined Fields: Journal from the Browse Fields drop down box and click Event Name, Table Number
  7. Select Save and Run under the Task Menu
  8. Choose your category and query
  9. At the bottom of the page choose a Delivery Option from the report format drop down box and then click Submit

You can find total ticket sales for the event by querying on the Approach of Tickets and the name of your event.
  1. Click Queries
  2. Click the Event Queries category
  3. Click New Query
  4. Name the query: Ticket Sales
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Approaches
  10. Choose Tickets
  11. Choose UDFs - Transactions from the Browse Fields drop down box
  12. Click Event Name
  13. Choose the event you want
  14. Click Save and Preview

Now, you may go to Report/Export and create a report definition to display more information about the ticket sales you created to help keep track of those sales.
  1. Select Reports in the menu bar
  2. Select the category you want to store this report under
  3. Select New Report under the Tasks Menu
  4. Name the report
  5. For Report Columns choose Sets from the Browse Fields drop down box and select Name and Address
  6. Choose Commonly Used Fields from the Browse Fields drop down box and select Date, Received
  7. Select User Defined Fields: Journal from the Browse Fields drop down box and select Event Name, Number of Persons Attending
  8. Select Save and Run under the Task Menu
  9. Choose your category and query
  10. At the bottom of the page choose a Delivery Option from the report format drop down box and then click Submit

You can find all gifts given to a particular event by querying on the Approach called Event and Event Name.
  1. Select Queries in the menu bar
  2. Select Event Queries
  3. Select New Query under the tasks menu
  4. Name the query Event Donations
  5. For Starting Query choose Category: Base and Query: All Constituents
  6. Set the Data Return Type to Journal Entries
  7. For Criteria Matching choose Match Each Criteria
  8. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  9. Click Approaches
  10. Choose Event
  11. Choose UDFs - Transactions from the Browse Fields drop down box
  12. Click Event Name
  13. Select the name of your event
  14. Click Save and Preview
Now, you may go to Report/Export and create a report definition to display more information about those donations.
  1. Select Reports in the menu bar
  2. Select the category you want to store this report under
  3. Select New Report under the Tasks Menu
  4. Name the report
  5. For Report Columns choose Sets from the Browse Fields drop down box and select Name and Address
  6. Choose Commonly Used Fields from the Browse Fields drop down box and select Date, Received, Fund
  7. Select User Defined Fields: Journal from the Browse Fields drop down box and select Event Name
  8. Select Save and Run under the Task Menu
  9. Choose your category and query
  10. At the bottom of the page choose a Delivery Option from the report format drop down box and then click Submit