Skip to Content
0

Adhoc query conditions Inclusive not Exclusive

Nov 08, 2016 at 11:49 AM

60

avatar image

I'm trying to design an adhoc query where there's multiple conditions, but I'd like it to include records where any of the criteria is met, rather then all the criteria being met.

I.e. I'd like it to show when EITHER:

Cost centre = 123456; OR
Personnel Area = XYZ; OR
Working Schedule = Z00000001

As at the moment, the query will only export records where all criteria is met.

Any help would be appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers