We have a query with three filters. One for Sold-To (with optional entry) and another for Ship-To (with optional entry). The thrid filter condition is based on cal month/year.
Now, the user wants the following way ( and they don't want to use the single values or ranges from the filter options)
First filter condition - Sold -To (ABCD) and Ship To (EFGH)
Second filter condition - Sold -To (JKLM) and Ship To (NOPQ)
Third...
Fourt....
Fifth......
upto 10 filter conditions..
With the common Cal month/year filter.
How can we achieve this? Advance Thanks.
BW Learner