FILTERS/QUERY: cannot change from AND to OR

(0) Share

Report

Posted on by Wolverine

569

I need to create a query with 2 groups. The first group will find records on or after X date AND on or before another date. The second group will also search on a date field, and this will also be an 'on or after' AND 'on or before'. I want to find records if either of these groups matches the query. However, when you open the Filter dialog, the AND is grayed out and can't be changed to an OR?!

1) Does anyone know why you can't change this to an OR?

2) Is there a way to change this to an OR?

If not, how can I get into the Old Query Designer, so that I can build my Query?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (1)

Report

FILTERS/QUERY: cannot change from AND to OR

Hi,

You can follow the steps below to set up the filter query.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Wolverine 569 on at

Like (0)

Report

FILTERS/QUERY: cannot change from AND to OR

Thanks. That is very helpful. Cheers.

It's a pity that the NEW interface is more time-consuming/takes longer than the old way. Not sure Microsoft understands what constitutes and improvement!

Was this reply helpful? Yes No