AND filter

[ppmc]

I have an order list with one line per article. As result i need a list with for example all orders with article1 AND article2. Can anyone help me to create an AND filter to the same field?

[#2]

Hi Wolfgang,

please drop a short data example in Excel or so.

Thank´s !

Rainer

[stephencredmond · Accepted solution]

If you have a table like this:

OrderID, ArticleID, Date, Price...

And one like this:

ArticleID, ArticleName, ...

Then you could do this:

A2:
Load Distinct OrderID, ArticleID As ArticleID2
Resident Orders;
Left Join Load Distinct ArticleID As ArticleID2, ArticleName As ArticleNameAND
Resident Articles;
Drop Field ArticleID2;

Then you can have "AND" mode in the list box for the ArticleNameAND field.

[ppmc]

Hi Rainer,

thank you fpr your interest. I got the right result with Stephen's answer.

Nice greetings

Wolfgang

[ppmc]

Hi Stephen,

thank you for your example. It works!

Nice greetings

Wolfgang