shadow9449
Registered User.
- Local time
- Today, 02:40
- Joined
- Mar 5, 2004
- Messages
- 1,037
It's fairly common to run a report using a combination of criteria from a list box. The way this is commonly done is by having a hidden text box create a list of items selected and then the query for the report uses an IN statement for the criteria to effectively OR the different criteria.
What I want to do is run a report where selecting multiple selections of the list box ANDs the criteria.
To be clear:
If the user selects "Apples", "Oranges", "Apricots", instead of running a report showing (for example, all clients who purchased) apples, oranges OR apricots (using the IN ('14', '12', '16') where the numbers represent product codes).
What I want different from the previous case is that the query written only shows clients who purchased ALL items selected.
Any suggestions?
Thank you
SHADOW
What I want to do is run a report where selecting multiple selections of the list box ANDs the criteria.
To be clear:
If the user selects "Apples", "Oranges", "Apricots", instead of running a report showing (for example, all clients who purchased) apples, oranges OR apricots (using the IN ('14', '12', '16') where the numbers represent product codes).
What I want different from the previous case is that the query written only shows clients who purchased ALL items selected.
Any suggestions?
Thank you
SHADOW