delete all instances of a data if a value on another field exsists?

[dtms1]

Is this even possible? I've read through many of the MS help pages and a lot of them refer to when having a 2nd table and using relationships. But the thing is my data only exists in a single table.

I'm trying to delete all instances of the data from a single table when one of the fields contains a value.

For example I have the following data:

Item Number	Received	Rejected
10-32	500
10-32	500
10-32	500
6-41	80	80
6-41	13
6-41	40
6-41	72
6-41	3
6-41	5
4-42	2
4-42	2
15565	300
15565	250
15565	90
15571	30	30
15571	32	32
15571	30
15571	30

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Where Item number is my main focus (grouping by this column)
and Received maybe something I'd like to sum up (with item number grouped)
And in rejected, if there is any rejected of 1 or greater than delete ALL item numbers with the same item number as the one with a rejection. even if some of the item numbers does not have a rejection (but same number).

How would I do that in the criteria line of query design?
Thank you for your time,
Ray