Counting unique values in a query

[DHIGHTO]

Hey guys,



I'm trying to get a count of unique or distinct values in a query. When I run sort-group by, I get unique values, but when I switch to count to sort, I'm getting a count of total count that includes duplicates. I'm trying to count the number of group by values (if that makes sense). Is there way to do this without writing it in SQL?

Thanks,

[JoeM]

Can you explain your table structure and post some sample data with your expected result?

[NTC]

In an Aggregate Query; where you have a field that is Group By; repeat that field but change its mode to Count

[DHIGHTO]

Can you explain your table structure and post some sample data with your expected result?

I was able to get a count of group by when I created a query searching for group by and then created another query to count.This is what I got, which is close to correct. I have more duplicate data from another table I have to weed out, but I did find what I was looking for.

EMP#	CountOfTFILE
101241	4
101605	29
105107	79
105169	81
107164	2
108605	34
109809	36
116483	25

[JoeM]

As NTC pointed out, an Aggregate Query should do what you want, and weed out the duplicates.