Query for 2 Objects

[mimireyes]

Hello,

When I query= In ("Widgets","Gadgets"), I get people that have ordered one or the other, or both.

I just want people who have ordered both and exclude those that have only purchased one of the two.

SO...

Jane: Widgets
Jane: Widgets
John: Gadgets
John: Gadgets
Rob: Widgets (<-this one I want)
Rob: Gadgets (<-this one I want)

Is that possible?

Thanks in advance!
Mimi

[recyan]

Just check out if below gives some guidelines :

SELECT 
    qryA.TheName, 
    Count(qryA.TheItem) AS CountOfTheItem
FROM 
(
    SELECT DISTINCT 
        myTable.TheName, 
        myTable.TheItem
    FROM 
        myTable
    WHERE 
        (((myTable.TheItem)="Widgets" Or (myTable.TheItem)="Gadgets"))
)
AS qryA
GROUP BY 
    qryA.TheName
HAVING 
    (((Count(qryA.TheItem))=2));

Thanks

[mimireyes]

I tried a version of this and it worked! Thanks so much.
Sorry for getting back to you so late.

[recyan]

Thanks