Linked table record count

  • Thread starter Thread starter Emma
  • Start date Start date
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
 
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
 
Back
Top