AnsweredAssumed Answered

Creating a Unique Fields report for two different fields in the same report

Question asked by ejolesch_1 on Nov 29, 2014
Latest reply on Nov 29, 2014 by philmodjunk

Title

Creating a Unique Fields report for two different fields in the same report

Post

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.

 

Thank you

 

Elliot

 

Outcomes