Skip to Content
0
Former Member
Feb 19, 2009 at 01:43 AM

In dire need of help - and clueless!

32 Views

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!!