Choose() with Or

[TippMan]

I have created a popup form which has an option group with 3 check boxes fo0r EmployeeStatus options: Active, Option Value=1; Recent Leaver=2, Former=3

The data I am querying is imported from a payroll program and has 4 status fields - 1=Current, 2=LeftThisYear, 3=LeftLastYear, 4=Former

I am trying to create a query which uses the value of the checked box on the popup form to filter the status field. I can not get it to return results for recent leavers i.e. where status = 2 or 3
I have been trying : Choose([Forms]![fdlgCo_Status]![Status],1,2 or 3,4) It works fine when Current or Former are ticked but not for Recent Leavers

How do you format "2 or 3" to get it to return if table status = 2 or = 3

 

[VilaRestal]

I think you could do it as:

where Choose([Forms]![fdlgCo_Status]![Status],'1','23','4') LIKE '*' & status & '*'

or

where InStr(Choose([Forms]![fdlgCo_Status]![Status],'1','23','4'),status) > 0


A bit of a bodge but maybe the only way other than

where status = Choose([Forms]![fdlgCo_Status]![Status],1,2,4)
or status = Choose([Forms]![fdlgCo_Status]![Status],1,3,4)

which is a bit horrible looking at the value of fdlgCo_Status.Status twice

 

[TippMan]

Thank you VilaRestal!

All your suggestions worked I just had to modify the field names, and I used these as the criteria for the ActiveStatus column:

1. Choose([Forms]![fdlgCo_Status]![Status],'1','23','4') Like '*' & [ActiveStatus] & '*'

2. InStr(Choose([Forms]![fdlgCo_Status]![Status],'1','23','4'),[ActiveStatus])>0

3. Choose([Forms]![fdlgCo_Status]![Status],1,2,4) Or ([tblNewHrData].[ActiveStatus])=Choose([Forms]![fdlgCo_Status]![Status],1,3,4)