AnsweredAssumed Answered

Summary field

Question asked by rowing190 on Oct 28, 2008
Latest reply on Oct 28, 2008 by bcooney

Title

Summary field

Post

Please bear with me, as I am new to the Filemaker Pro database. I have set up a rather straightforward database with a company table and a contact table. The tables are related to one another by a company id field. Here is the problem. When querying the contact database - for example, for the number of marketing communications executives in Illinois - for a marketing campaign - I would like to know the number of companies as well as the number of contacts that match the find criteria. I have attempted to create a summary field in a trailing grand summary report, but the number that it returns is the same as the number of contacts. That is, there are say 901 contacts that meet the criteria, but they represent only say 303 companies. The grand total of companies in the trailing grand summary is also 901 since each contact has a company id. The sub-summary section will show the number of contacts for each company id - for example, company id x001 = 6 - but the grand total in the trailing grand summary totals 901 companies. Any idea how to create a grand total field for the number of companies that counts each unique company id only once and gives the correct total of 303 companies? I have been querying both the contact and the company databases in order to get the correct counts, but surely there is some way not to have to query the company database. Any help would be appreciated.

 

Thank you. 

Outcomes