Query Criteria

[BorisGomel]

Hello ,

It is silly problem I am facing , but I pretty much stuck. I have simple cross query in which I am trying filter the records by three criteria for the text such as ACH-ePayment, ACH-JST Recur Payme and ACH-Disc Rec Payment . My SQL in query is :

Not ("ACH-ePayment")
("ACH-JST Recur Payme")
("ACH-Disc Rec ")
iT doesn't work .It filters by first critiria and I had to make two more quries to filter the record by last two cretirias.



Any advise how can I accomplish this in one query .

Thank you,

The Best Regards,

BorisGomel

[pbaldy]

Try

Not In("ACH-ePayment","ACH-JST Recur Payme","ACH-Disc Rec ")

[BorisGomel]

Thank you so much!!!

Will remember this trick .

It is working!!

The Best Regards.

BorisGomel

[pbaldy]

Happy to help!