Multi-Select Filter

[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

 

[Sandra Daigle]

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#)