Getting duplicate rows using distinct

[nondrinker]

Hello,
I am trying to display records related to same client ID
who has products in more than one product group in one row instead of different rows for the same clientid.

For example, instead of getting an output like

ClientID ProductGroup
1 PG1
1 PG2
1 PG3


I am trying to get an output in just one row, like:
ClientID PG1 PG2 PG3
1 yes Yes Yes


I am using a distint clause in my query, but whenever i use the ProductGroup field in my query i start getting the duplicate rows for the same clientId.
Is there any work around for this problem?
Thank you.

 

[dhookom]

I think you want a crosstab query. Set ClientId as the Row Heading, ProductGroup as the Column Heading, and TheValue:"Yes" as the Value.

Duane
MS Access MVP

 

[johnnymac43]

Take a look at thread181-511702 for a method of attacking this requirement.

John