Query Criteria???

[Annabelle]

I have a query that includes a field for ModelID and one for MotorID. The criteria for ModelID is 125 (for ModelID 125). The criteria for MotorID is a range of numbers, not necessarily consecutive. MotorID = 6,16,17,18,19,20,21,30. (The motors with these MotorIDs are the only motors available for that model.)

At present, I have separate criteria lines for each MotorID. So the ModelID is repetitive on each criteria line.

Is there a way to achieve this using only one criteria line?

Help is very much appreciated. Thank you.

 

[Jack Cowley]

Use the In operator in your criteria. I.e. In(6, 16, 17, etc.).

hth,
Jack