Creating a Unique Fields report for two different fields in the same report
I'm not sure what I am trying to accomplish can be done but here goes.....
I am working with an event organizer to enter event information into a FM DB. I have the information in the DB but it does have some holes in the data and I am trying to generate one report that will provide two pieces of information.
1) The number of records for a particular event. I think that I have successfully created that report using a self-join (based on an answer I found here).
2) We have captured email addresses for the participants of each event, but there are some missing. I would like to add to my first report, the number of emails addresses that have been captured.
The layout of the report would look something like this ----
Name of Event Number of Records for the Event Number of Email Addresses Captured per Event
I would also like to create a Grand Summary for the entire report.
I have been able to create the report for Part I, but I am struggling on how to create Part 2 of the report.
Any guidance or assistance is greatly appreciated.