Perform IN Query with Parameter in Access 2003

[barnard90]

I am using Access 2003 database.

I have an employee table with fields
Empno, EmpName, Day_worked fields

Day_worked have values like 'Sunday', 'Monday', Tuesday'..etc

I am trying to parameterized query a table like

Select * from Employees where
Day_worked In ([P1])

Here P1 is a parameter where I can pass on multiple values like 'Sunday', 'Monday' ,'Tuesday'...etc at the same time
How can I do it . At present I am able to pass only one value. I would like to pass multiple values at same time.

thanks

 

[SkipVought]

Day worked as STRINGS equaling the day of week???

What happends NEXT week?

How do you know the DATES worked?

I think you have a problem in your table design.

Short answer, Parameters cannot fill an IN statement, VBA Can.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[barnard90]

The day_worked has the values of the day in the week
They are like Sunday , Monday , Tuesday...etc
They are not numerics like 10th, 11th, 12th etc

Could I have a single parameter in MS access 2003 which would yield me a single query from a single a paramter like

Select * from Emoloyees where day_worked IN
('Sunday','Monday','Tuesday','Wednesday','Friday')

Please suggest

 

[SkipVought]

"They are like Sunday , Monday , Tuesday...etc"

I already got that.

What happens when LAST week, and the week before that AND the week before that, I worked MONDAY & TUESDAY & WEDNESDAY & THURSDAY & FRIDAY, but not THIS WEEK?

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[PHV]

WHERE InStr(',' & P1 & ',', ',' & Day_worked & ',') > 0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886