One to Many Report counts

D

DavidSt

I have 2 tables that are linked via a one (TableA) to many (TableB)
relationship.

Lets say TableA has 50 records and TableB has 113 Records.

I have a report that uses a sum/count function such as:

=Sum([CountOfRecordsInTableA])

This works fine for counting the records in that table.

....In the same report page, I would like to include a similar count for
TableB.

When I link the two tables in the report query; the results always count the
total records (TableB) and I lose the accurate count for TableA.

Is there any way to do this?
 
D

Duane Hookom

In a report, you can create a group header on the unique field in TableA.
Add a text box in this header section:
Name: txtCountA
Control Source: =1
Running Sum: Over All
Then add a text box to the report footer:
Control Source: =txtCountA
 
Top