I have an access database with a table of data (DATA).
I then have another table with a list of names (NAMES).
I then have a query run off the DATA which counts up the number of times each name appears.
What I would like is to able to perform a calculation with the Query results and NAMES table.
The names table holds 5 names (A, B, C, D, E)
The Query then returns the number of times those names appear in the DATA table. What I would like is not the number of times that the name appears but 7 minus the number of times it appears. So if A appears 5 times I want the result to show as 2.