summary field in report from related table
I do probation. I have a "clients" table, related to "drug tests", "contacts", "community service", and "curfew checks". Each of the tables has a summary field, so I can run a report to show me, for example How many drug tests I've administered. I want to be able to run a report on "clients" that will show me for each client, how many of each of those activities I've done with each specific client. I've tried placing the summary field from each of the related tables on a report based on the "clients" table, and i just get garbage.