Re: Using IN Operator in ADO Rs.Filter ?

Nothing like that is supported, the closest you can get is:

InvoiceNo = 123 or InvoiceNo = 345 [etc]

-Mark


"Luqman" <pearlsoft@xxxxxxxxxxxx> wrote in message
news:u9RzYfQ2FHA.2816@xxxxxxxxxxxxxxxxxxxxxxx
> Is it possible to use IN Operator or Similar functionality in Rs.Filter ?
>
> for example:
>
> rs.filter="InvoiceNo IN '123,345'
>
> Which should show only Records of Invoice No. 123 and Invoice No. 345.
>
>
> Any idea please ?
>
> Best Regards,
>
> Luqman
>
>


.

Relevant Pages

  • Using IN Operator in ADO Rs.Filter ?
    ... Is it possible to use IN Operator or Similar functionality in Rs.Filter? ... Which should show only Records of Invoice No. 123 and Invoice No. 345. ... Luqman ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: "Yahoo briefcase"-like app?
    ... like weeblefm is closest to the functionality I was ... browsers don't include PUT functionality). ... Weeble seems to fit the bill pretty well. ...
    (Debian-User)
  • Re: Filer rows in Excel
    ... About the closest thing you can do is to select some columns and use Data|Group. ... I guess you could use View|Custom views to hide/show columns, ... But all of those don't give the functionality of data|filter|autofilter. ... Of course I know how to filter columns in Excel, but is there also a way to ...
    (microsoft.public.excel.misc)
  • inversion of a language as embedded language.
    ... functionality to provide an embedded language within input data? ... closest thing I can think of is macros but this seems more specific ...
    (comp.lang.misc)