Prev: problem with query in ASP using date()
Next: Where Not Exists
From: yuvalbra via AccessMonster.com on 24 Dec 2009 07:10
Thanks Thanks
I will try it

KARL DEWEY wrote:
>This does what you ask --
>SELECT field1
>FROM tbl1
>ORDER BY IIF(InStr([field1], [Enter Value1]) >0, 1, 0) + IIF(InStr([field1],
>[Enter Value2]) >0, 1, 0) + IIF(InStr([field1], [Enter Value3]) >0, 1, 0)
>DESC;
>
>> I mean:
>>
>[quoted text clipped - 30 lines]
>> >>
>> >> .

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: problem with query in ASP using date()
Next: Where Not Exists