I am using about 12 different queries, including many joins, as the datasource for a single UltraGrid and it works great! But one new issue has come up.

There is a Client table many to many relationship with Categories. If I say

SELECT DISTINCT
                      Client.MainClientID, Client.ClientName, Client.ClientNumber, Client.CPA, Client.Staff, Client.OfficePhone, Client.CellPhone,
                      Client.HomePhone, Client.FaxNumber, Client.Email, Client.TIN, Client.Active
FROM         (Client INNER JOIN
                      CategoryClient ON Client.MainClientID = CategoryClient.CategoryClientID)
WHERE (CategoryClient.CategoryName = pCategoryName1 OR
                      CategoryClient.CategoryName = pCategoryName2)

Without DISTINCT, if the exact same client had both pCategory1 and pCategory2 (set at runtime) I would get dups of course and it would bomb since the grid really is bound to a straight Client table and expects unique ID's.

That works prefectly *but* give an OR result. Now he wants an AND result, but each returned record has only 1 category field, by definition.

So what I need is the *opposite* of DISTINCT.

**I want it to exclude ONLY records that are ARE duplicated in the results, but still only give me one instance of each of those.**

I can do this though code of course in an intermediate table, but he wants to do his own custom reports directly in Access.

I realize this is more a SQL question than a Infragistics question really, but the UltraGrid is the final display layer and I get better results with this forum than any other.