AND Within a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
ashg657 said:
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.
Click to expand...

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
 
Back
Top