filter by two items

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a macro that filters by our members status. Right
now it filters only the active members and I need it to
filter by both "Active" and "AR - Active". Right now my
macro looks like: (([Customer Profile Sheet].[Status]
="Active")). Could anyone tell me how filter by "Active"
and "AR - Active". Thanks
 
I have a macro that filters by our members status. Right
now it filters only the active members and I need it to
filter by both "Active" and "AR - Active". Right now my
macro looks like: (([Customer Profile Sheet].[Status]
="Active")). Could anyone tell me how filter by "Active"
and "AR - Active". Thanks
Click to expand...

The words "and" and "or" are both English language conjunctions, and
also logical operators. This can lead to some confusion. The logical
operator AND returns TRUE if both its arguments are TRUE; the operator
OR returns TRUE if either one of the arguments, or both, are TRUE.

So if your filter were

[Status] = "Active" AND [Status] = "AR - Active"

you would not retrieve ANY records, because if one of those arguments
is true, the other one must be false (i.e. if the status field
contains "AR - Active" then you KNOW that it does not contain just
"Active").

Use the criterion

[Customer Profile Sheet].[Status] = "Active" OR [Customer Profile
Sheet].[Status] = "AR - Active"
 
Back
Top