I am trying to write a very simple report using one access database with two tables.
Table 1 = ID# - same ID# can be repeated several times (duplicated)
Table 2 = contains 1, 2, 3 ,4
What results do I need? I need to count the number of "1's", then "2's", then "3's" and then "4's" and sum the total of each (1,2,3,4) The problem - I only want to count the number of ones where ID# is Distinct (no duplicates)
In my head, I keep coming up with a formula such as "Disticnt Count" field is ID# where table 2 contains a "1"
I can do a distict count of ID number and get the total of all "1's, 2's, 3's and 4's. But what I need is a distict count by ID# if table 2 = "1"
Overall, it requies a distict count of one field based on values in a second field
Ayy help appreciated, my boss needs it yesterday
Thank You!!