report on multiple contacts

Hello James, 

If you would like to try an approach that doesn't require updating the account records an Advanced Report could do it. 
Create the following custom query: 

SELECT a.id, a.name, COUNT(ac.contact_id) as contact_count
FROM accounts_contacts ac
JOIN accounts a ON ac.account_id = a.id
GROUP BY a.id, a.name
HAVING COUNT(ac.contact_id) > 1;

And use it to create an Advanced Report.
This will list all the accounts with more than one contact related. 

I hope this helps

André

Hello James, 

If you would like to try an approach that doesn't require updating the account records an Advanced Report could do it. 
Create the following custom query: 

SELECT a.id, a.name, COUNT(ac.contact_id) as contact_count
FROM accounts_contacts ac
JOIN accounts a ON ac.account_id = a.id
GROUP BY a.id, a.name
HAVING COUNT(ac.contact_id) > 1;

And use it to create an Advanced Report.
This will list all the accounts with more than one contact related. 

I hope this helps

André