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 Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Click New Query
  5. Name the query: RSVP
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching select Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Journal Entry Date
  11. Fill in the date of the event
  12. Choose Defined Fields from the Browse Fields drop down box
  13. Click Contact Method
  14. Choose Event Accepted
  15. 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 Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Click New Query
  5. Name the query: Attended
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Journal Entry Date
  11. Fill in the date of the event
  12. Choose Defined Fields from the Browse Fields drop down box
  13. Click Contact Method
  14. Choose Event Attended
  15. 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 Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Click New Query
  5. Name the query: Did not RSVP
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Journal Entry Date
  11. Type in the date of the event
  12. Choose Defined Fields from the Browse Fields drop down box
  13. Click Contact Method
  14. Choose Event Invited
  15. 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 Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Click New Query
  5. Name the query: Invited
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose UDFs - Contacts from the Browse Fields drop down box
  10. Click Event Name
  11. Choose the Event you want
  12. 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. Click Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Select New Query under the tasks menu
  5. Name the query Table Assignments
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Journal Entry Date
  11. Fill in the date of the event
  12. Choose UDFs - Contact from the Browse Fields drop down menu
  13. Click Table Number
  14. Select field has any value
  15. Click Save and Preview

Here is a report to display more information about your table assignments.
  1. Select Reports in the menu bar
  2. Click Manage Reports
  3. Select the category you want to store this report under OR create a new category by clicking New Category from the Tasks menu on the left.
  4. Select New Report under the Tasks Menu
  5. Name the report
  6. For Report Columns choose Commonly Used Fields from the Browse Fields drop down box and click Name, Date
  7. Select User Defined Fields: Journal from the Browse Fields drop down box and click Event Name, Table Number
  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 total ticket sales for the event by querying on the Approach of Tickets and the name of your event.
  1. Click Queries
  2. Click Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Click New Query
  5. Name the query: Ticket Sales
  6. Set the Starting Query to Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Approaches
  11. Choose Tickets
  12. Choose UDFs - Transactions from the Browse Fields drop down box
  13. Click Event Name
  14. Choose the event you want
  15. 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. Click Manage Reports
  3. Select the category you want to store this report under OR create a new report category by clicking on the New
  4. Select New Report under the Tasks Menu
  5. Name the report
  6. For Report Columns choose Sets from the Browse Fields drop down box and select Name and Address
  7. Choose Commonly Used Fields from the Browse Fields drop down box and select Date, Received
  8. Select User Defined Fields: Journal from the Browse Fields drop down box and select Event Name, Number of Persons Attending
  9. Select Save and Run under the Task Menu
  10. Choose your category and query
  11. 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. Click on Manage Queries
  3. Click the heading for the query category you want to save the new query to OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Select New Query under the Tasks menu
  5. Name the query Event Donations
  6. For Starting Query choose Category: Base and Query: All Constituents
  7. Set the Data Return Type to Journal Entries
  8. For Criteria Matching choose Match Each Criteria
  9. For Criteria choose Commonly Used Fields from the Browse Fields drop down box
  10. Click Approaches
  11. Choose Event
  12. Choose UDFs - Transactions from the Browse Fields drop down box
  13. Click Event Name
  14. Select the name of your event
  15. 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. Click Manage Reports
  3. Select the category you want to store this report under OR create a new category by clicking on the New Category link under the Tasks menu on the left.
  4. Select New Report under the Tasks Menu
  5. Name the report
  6. For Report Columns choose Sets from the Browse Fields drop down box and select Name and Address
  7. Choose Commonly Used Fields from the Browse Fields drop down box and select Date, Received, Fund
  8. Select User Defined Fields: Journal from the Browse Fields drop down box and select Event Name
  9. Select Save and Run under the Task Menu
  10. Choose your category and query
  11. At the bottom of the page choose a Delivery Option from the report format drop down box and then click Submit