ANDs and ORs are allowed in filters.  You just have to use the proper 
syntax to avoid that error from ocurring.

Please visit this link for more info:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q235892


> You can on set a filter on one "condition" that is no ANDs ORs etc... 
only a
> equality operator.
> 
> It would be better to compose the SQL WHERE statement to return what you 
need.
> 
> -- Tomm
> 
> > -----Original Message-----
> > From: Ethan Selzer [mailto:ethanselzer@m...]
> > Sent: Friday, December 21, 2001 5:42 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] RE: Using Recordset.Filter to filter 
out
> > records with null
> >
> >
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235892
> >
> > -----Original Message-----
> > From: Norman Tse [mailto:tse@p...]
> > Sent: Friday, December 21, 2001 9:53 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] Using Recordset.Filter to filter out 
records
> > with null
> >
> > Hi,
> >
> > How can I use set Filter property in Recordset in order to retrieve all
> > records with null value in a particular fields? I have an error as 
below:
> >
> > rs.Filter = "LastName='Smith' and hireDate is null"
> > ADODB.Recordset error '800a0bb9'
> >
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another
> >
> > Regards,
> > Norman
> >
> > $subst('Email.Unsub').
> >
> >
> > $subst('Email.Unsub').
>