Multi-Select Filter

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
 
S

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