Skip to Content
avatar image
Former Member

Adhoc query conditions Inclusive not Exclusive

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers