Filtering with multiple variables

I am trying to find certain ID's in a table. The table has a column named User ID. I want to find multiple differnt ID's I am having trouble making my filter work. This is what I have most recently tried.

Instr("11111","Patient ID") .or. "Patient ID" = "222222" .or. "Patient ID" = "333333"

Any help is appreciated.

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Altair Forum User

Vaughn,

Create a filter that states [UserID] .In. ('11111','22222','33333','444444')

You get the idea.....

Altair Forum User

Sorry I think you stated your field was "Patient ID"

So try

[Patient ID] .In. ('11111','22222','33333','444444')

Altair Forum User

Sorry I think you stated your field was "Patient ID"
So try
[Patient ID] .In. ('11111','22222','33333','444444')

This worked like a charm thank you.

Altair Forum User

This worked like a charm thank you.

Vaughn,

Is this something you need to to with different lists of IDs on a regular basis?

If so would you be expecting to change the model and edit the filter each time?

Subject to which version of Monarch you are using there may be some ways of enhancing such a process for repetitive use - if that is of interest to you.

Grant