criteria help needed

[Jman883]

I have a querie made to run a report. Criteria in the querie is
[Enter shift number 1,2, or 3 to view shift]
This filters for 1,2,or 3. what would I need to add to run all 3?
I would like to run all 1,2,and 3 or just 1 or 2 or 3.

Thanks

 

[Jon K]

Assuming you have a Shift field storing the numbers 1, 2 or 3 for each record, you can use the InStr() function in the SQL View of the query like this:-

SELECT *
FROM [TableName]
WHERE InStr([Enter shift number 1, 2, or 3 to view shift], [Shift]);
.

 

[rpadams]

This also would work:

Criteria--> like [Input Shift 1,2,3 Blank=All]&"*"

 

[Jman883]

That did it, Thanks