selecting certain items

[vbgladiator]

hey,

I have the following table which keeps track of items in a kit.
fields: kitid, inventoryid, qty.

I want to pull out kitids that have 2 items in them (7845 and 6340).
I can do it if either one is in them but can't get to show only ones that have both items in them.

Thanks,

MA

[YWLMB]

are you using an SQL query?

[gavio]

SELECT *
FROM SOMETABLE
WHERE KITID=7845
OR KITID=6340

... if i understand you correctly.

[YWLMB]

SELECT *
FROM SOMETABLE
WHERE KITID=7845
OR KITID=6340

How can KITID have both items in it?
Can you give me a sample of both items being in it?