Dbase Report - Mix Contact1 and Conthist

[StuartStarrs]

I am trying to create a report that counts the number of calls we have made to a particular Industry Type (Key1 Field). The report will be sorted by the Key1 field and underneath will be the total of completed activites to that particular trade. The problem I am having is getting the report to link the data in Conthist to link with the data in Contact1. I'm not sure this is very clear so here is a breakdown of the data setup: Industry Type field in Contact 1, there will be phone calls made to people in different Industries, Count how many calls we have made to people of a particular trade. How do I link the Contact1 table to the Conthist table. Thanks

 

[ddeegan]

Hello

Contact1 & Conthist link by accountno.

You could try the reports that come w/Gmine.

File | Print Reports | select "Contact Reports" under report categories

one to try could be "History & Referrals Report", right click and select "Clone" (same idea as Save As...) and you should be able to modify the report to your needs there.

I'm not sure "History & Referrals Report" has a total, but one of the gm reports should have it.

Good Luck
Dave