How to: Function or Rollup to count # of records linked that match X


#1

Hello! Does anyone know how I can pull something like this off?

In my first column of my master table I have a column called “Serial Number” in the second column I have a “Log” that are linked records from another table.

What I want to do is in the third column, is count how many unique records are in my “log”


#2

Do you want to know how many unique records are linked from each record in your master (serial number) table, or do you want to know how many unique logs are linked-to by all records in [Master]? That is, do you want to know {Serial Number} 'SN001' has 5 links to [Log], representing links to three unique [Log] records, or do you want to know, of the twenty unique records in [Log], {Serial Numbers} 'SN001', 'SN002', and 'SN004' link to eight? Both are possible, but they use different techniques.