Linked table record count

E

Emma

Is there an easy way to list records in one table and a
count of the number of related records in a linked table
for each record?

For instance:
Tbl1-rec1 # of related records in tbl2
Tbl1-rec2 # of related records in tbl2
 
T

Ted Allen

Hi Emma,

You can just create a totals query based on the two
tables. Group by Table 1 ID and Count the corresponding
foreign key field in Table 2.

Post back if you haven't used totals queries before and I
will be happy to give more detail.

HTH, Ted Allen
 
Top