Distinct Values

[Acramer8]

Good Afternoon,



Background-
I am working on a report that gives a summary of quality samples. We have 2 departments who do quality samples. "Internal Audit" and "PSO Quality". Unfortunately, "Internal audit" will put the same sample number in multiple times which gives me an invalid count.

Need-
I want to be able to report the number of Distinct samples done by "Internal Audit" as well as "PSO Quality".

I have already tried:
Subquery - Not smart enough I suppose
ECount - Again???

Your help would be greatly appreciated!

Thanks,
Adam

[hawzmolly]

Try opening your query in SQL and change "SELECT" to "SELECT DISTINCT" or "SELECT" to "SELECT DISTINCTROW"