Having passed a big birthday this week I suspect I am getting too old for this game!
I cannot figure out how to create an update query that will count the number of linked records and paste this number back into the master record.
The master records are a list of members of a society and the linked table is a list of groups to which each member belongs. This also links to a table of groups.
So Member 1 belongs to groups 2,5,9
Member 2 belongs to groups 1, 11, 14, 17
I need to insert counts of 3 and 4 into Member records 1 and 2.
Sounds easy!
But how?
I cannot figure out how to create an update query that will count the number of linked records and paste this number back into the master record.
The master records are a list of members of a society and the linked table is a list of groups to which each member belongs. This also links to a table of groups.
So Member 1 belongs to groups 2,5,9
Member 2 belongs to groups 1, 11, 14, 17
I need to insert counts of 3 and 4 into Member records 1 and 2.
Sounds easy!
But how?