AND Within a filter

[Guest]

Hi, here's the problem code:

Reports("debtorsnew").Filter = "selected =" & tr(m)" And [VISITOR] = True"

Yes, I'm trying to filter a report based on the VBA filter specified above.
But Im getting Type Mistmatch and query expression errors. Ive tried messing
around with speech marks and apostrophes but i'm not getting anywhere.

Please could someone help me out, this one is doing my head in.
Thanks in advance,

Ash.

 

[Keith Wilby]

Hi, here's the problem code:

Reports("debtorsnew").Filter = "selected =" & tr(m)" And [VISITOR] = True"

Yes, I'm trying to filter a report based on the VBA filter specified
above.
But Im getting Type Mistmatch and query expression errors. Ive tried
messing
around with speech marks and apostrophes but i'm not getting anywhere.

Please could someone help me out, this one is doing my head in.
Thanks in advance,

Ash.

Well the first thing to jump out is a missing ampersand before the
penultimate quotation mark, but what is "tr(m)"?

Keith.
www.keithwilby.com