Multi-Select Filter

  • Thread starter Thread starter Bandit
  • Start date Start date
B

Bandit

Hi,
I have done filters before where you chose 1 Account, 1
Category, 1 Client, a Start Date and an End Date. But how
to you code it if there can be more than one Account? The
user needs to be able to have in strWhere AccountID = 1 OR
5 OR 8 OR 11 and (visitdate between #7/20/2004# AND
#7/27/2004#).

Thanks,
Bandit
 
There are two ways:

(Accountid = 1
Or AccountID=5
Or AccountID=8
Or AccountID=11) AND
(visitdate between #7/20/2004# AND #7/27/2004#)

The second is

Accountid In(1,5,8,11)
AND (visitdate between #7/20/2004# AND #7/27/2004#)
 
Back
Top