duplication

[Joel]

Hello,

Let's say I have a query. There are three columns in my query. Balloon
size, color, and type.

Let's say the first record of my query is Large, Red, Metallic.
The second record is Small, Red, Metallic.

I want to make a rule that says if there is already a record in my query
that has the same color and type, do not show up in the query. Therefore,
in this example, only the Large, Red, Metallic record would show.

How do I do that?

Thanks for your help - Joel

 

[Les]

Joel,
Try creating a totals query. Group by color, group by
color, and first for size.