How do I pass a set of values into an IN operator without it treating all the values as one string?
The attachment has the saved query.
Need help - thanks
p4willi
Code:
If [Forms]![frmList]![cbo_frmlist_as].Value = "ALL" Then
[Forms]![frmList]![hide_frmlist_as] = "PENDING" & "," & "CLOSED" & "," & "REVIEW"
Need help - thanks
p4willi