Select Unique Records

[Daren]

Hello,
I have one table with which I am working in a query. The filelds in the
query are State, Participation Code, and Participation Code (again to show
counts). I have grouped by State and Participation Code, and set Count for
counting Participation Code, which can be Y or N in query design view. How
can I modify this query to only include unique data? Should I include other
fields? Thanks.

 

[StrayBullet via AccessMonster.com]

What results are you getting? For example, are you getting

CA, Code1, 3
CA, Code1, 3
CA, Code1, 3
etc

or

CA,Code1, 3
CA, Code2,1
WA, Code1, 2
etc

Properly grouped, each result row should be distinct (as in the second
example). Unless of course, code or state is free-enter text and there exists
entries such as CA, Cal., CA., Cali - all of which Access would consider
unique values (even though we would read them each as California)