Multiple conditions for filter property

[jluost1]

Can someone tell me how to set multiple conditions in form "WHERE" or filer property?

Thanks.

 

[tlbroadbent]

Use AND or OR for multiple conditions. You can also use BETWEEN for ranges and IN to look for multiple conditions. Check the SQL BOL for help with SELECT statements and WHERE clauses.

Examples:

Where ColA=5 and ColB<21
Where ColA=5 OR ColA=7
Where ColA Betweeen 'jan 21 2001' AND Feb 14 2001'
Where ColA In ('John','Mary','Michael','Janet')
Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin