I am having problems with and or/and filter. The attached jpg shows the filter as I now have it.
When i run this, it looks as though the field "EmployeeId" in Filter 1 does not work. I get almost 9000 records when there should only be 147.
If I run each filter separately, Filter 1 gives my 145 records and then Filter 2 gives me 2 records, which are exactly the records I am looking.
So I know Filter 1 and Filter 2 are correct, but when I use the Logic "or" as in the jpg, it does not work.
How have I coded this wrong.
Thanks in advance.