Report Count

[erinkleiman]

I have a report in which there are a list of number with the duplicates hidden. At the end of the report I wish to Count all of these numbers, NOT including the duplicates. When I do the count at the footer it still counts the duplicate numbers. How can I count only distinct numbers?

 

[Alexandre]

Why don't you eliminate the duplicates from your underlying query if they are of no use to you? (see the unique values and unique records properties of your query and look up DISTCINCT / DISTINCTROWS in access help)

 

[erinkleiman]

I need the duplicate values in the underlying query because I need to report on the related information.

 

[Alexandre]

Uneasy to help further without a better idea of what you are doing. Coudl you try to post your DB ?
I suspect there may be a better approach to what you are doing like using Dcount, or another query or subreports...