Query Criteria for repeated Item

[rashock]

Hi, I have a list of objects that should have 5 or more packages of rules

Example:
ITEM RULE
118 RED
118 BLUE
118 YELLOW
118 GREEN
118 ORANGE



Each item must have all the first 2 rules 1 time but the last 2 rules can be repeated
If the Item dont have at least 1 time each rule then delete the item

[June7]

Are you saying this is acceptable:

118 RED
118 BLUE
118 YELLOW
118 GREEN
118 GREEN

but not:

118 RED
118 RED
118 YELLOW
118 GREEN
118 ORANGE

[rashock]

Yes, you got it

[June7]

This is criteria that is dependent on value(s) in other record(s) of same table. Always tricky. Look at this simple example https://www.accessforums.net/access/...ery-41081.html

I think yours may be beyond capabilities of a query and will need a VBA procedure.