Counting Minus Duplicates

A

artregdlg

I have a report where I need to count the number of individuals confined by
ethnicity. In this report I can not count not individual who confined more
than once during a particular time period.

I have the following columns:
LastName, Gender, and DateConfined (along with others that need not be used)

My report shows (Example)

Jones, AA, 10/04/04
Jones, AA, 10/0704
Last, AA. 09/17/04
Last, AA, 10/04/04

All my counts, sums, or abs end up with a total of 4(four).
I need the report to only show 2 (two) counts of ethnicity because I need
not to count the duplicate individuals.

I have removed the duplication of the last name, but counting the LastName
seems to not work either.

I have tried various counts, sums, abs, but still getting the total number
not the total number minus duplications.

Thanks in advance for the help
 
D

Duane Hookom

You can create a grouping level with a header (could be very short) on
LastName,... Add a text box to the group header
Name: txtCount
Control Source: =1
Running Sum: Over Report
Then add a text box to the report footer
Control Source: =txtCount
 
A

artregdlg

I tried your suggestion and I was comming up with a total not subtotals.

Maybe I explained it wrong.
I have LastName, Gender, DateConfined
A, AA, 10/10/97
A, AA, 11/12/97
B, CA, 01/05/97
C, AS, 02/03/98
C, AS, 03/05/98

My report needs to let me know that there are
2(two) AA
1(one) CA
2(two) AS

I can only achieve a complete total of 5(five)Individuals .

Some How I need to group the gender and hide duplicates of last name and
count the number of genders not duplicting the last name.

Hope you can help.

Regina
 
D

Duane Hookom

Create a totals query or queries that generate your values and base your
report on the new query.
 
A

artregdlg

Duane,
I did as you suggested and I succeeded. I told my boss that when adding the
additional fields (which have duplicates of their own) makes the errors.
thanks for the help.
 
Top