SQL Syntax error 2

[Trudye]

Hi Guys, I can't seem to get the syntax right. gItemID is an integer; rs2!item is string.

Error I'm getting: Expecting Expression (it highlights the single quote immediately following DealDetailTracking.Item=.

SQL STATEMENT:
strSQL = "SELECT qty, completed, DetailLineID, itemid, item from DealDetailTracking "
strSQL = strSQL & "where ItemId = " & gItemID AND DealDetailTracking.Item= '" & rs2!item & "'"

Thanx so much,
Trudye

 

[RoyVidar]

Second line missing some concatenation operator and quote:

[tt]strSQL = strSQL & "where ItemId = " & gItemID [red]& "[/red] AND DealDetailTracking.Item= '" & rs2!item & "'"[/tt]

Roy-Vidar

 

[cmmrfrds]

strSQL = strSQL & "where ItemId = " & gItemID & " AND DealDetailTracking.Item = '" & rs2!item & "'"

 

[Trudye]

Thanks Guys it worked like a charm.

Trudye