Think I posted this in the wrong forum initially, so forgive me for double-posting. I inherited an Access report that has the following filter (found this on the Property Sheet):

[Dept]="1942"

I need to modify it to include another dept (1941). I have tried several ways but none work:

[Dept]="1942","1941"
[Dept] IN "1942","1941"
[Dept] In "1942","1941"
[Dept] In List "1942","1941"
[Dept] In List ("1942","1941")

I have very limited experience with Access, and I'd greatly appreciate it if anyone could tell me the correct syntax to pull both depts. If it matters, the Record Source is a query, but the query itself does not have any selection criteria regarding depts.

Many thanks,
Steve

try this....

[Dept]="1942" and [Dept] = "1941"

Thanks! "and" didn't work - no one has more than one dept - but "or" did. Thanks again..

i had a 50/50 chance of being right. You had the right idea with the first thing you tried. Access like most programs need to be told every single detail over and over again.

Humans know that if dept = 41 or 42 that we mean dept = 41 or dept = 42.

Computers say error what is a 42.

Glad you were able to get it working.

good luck with the rest of the project.