Help figure out what's wrong with this syntax

[perryc]

All,


I am just a beginning with VBScript in Access. I am sure it will be very easy for you to spot what I did wrong below. I am trying to filter "Referrals" where Payors appears in a multiple search list, as well as DeclineReasons in a multiple search list PLUS the PCriterias, which is a bunch of other fields. Ty for your help in advance.

Task = "select * from Referrals where ([Payor] in (" & StrSearch & ") & [DeclineReasons] in (" & StrSearch2 & "))" & " AND " & PCriteria


Sincerely,
Perry

[June7]

Use AND in place of the & character in front of [DeclineReasons].

Task = "SELECT * FROM Referrals WHERE ([Payor] IN (" & StrSearch & ") AND [DeclineReasons] IN (" & StrSearch2 & ")) AND " & PCriteria

[moke123]

Try adding a debug.Print Task - to see what the sql resolves to. Should help you to see whats wrong.

[perryc]

June7, ty, as easy as that! and ty for the tip, Moke123 as well.