Hi Guys, not sure how the syntax works on this one.
strSQL = "SELECT max(cost) as MaxCardsfrom DealDetail_Hdr WHERE clientid =" & sID & " And Item = '" & Card(s) & "'"
Access is complaining about:[blue]'" & Card(s) & "'"
[/blue]portion of the statement.
Any ideas?
Thanx much,
Trudye
strSQL = "SELECT max(cost) as MaxCardsfrom DealDetail_Hdr WHERE clientid =" & sID & " And Item = '" & Card(s) & "'"
Access is complaining about:[blue]'" & Card(s) & "'"
[/blue]portion of the statement.
Any ideas?
Thanx much,
Trudye