Simple Query Query

[archn01]

All I want to do is run a query based on differing items within the same ID field.

e.g. Here are 2 items that the field may containg
1) IB-SS-MB
2) LCIS-GP-MB

How do I query the field for all rows that contain MB & IB?

 

[pdx_man]

Look up the Like operator in Access Help.

Criteria line: Like "*IB*" AND Like "*MB*"