This is my sql statement:
sqlstr = "SELECT LoanTab.TransId, ItemTab.Item, relationTab.Quantity FROM ItemTab INNER JOIN

relationTab ON ItemTab.ItemId = relationTab.ItemId INNER JOIN

LoanTab ON relationTab.TransactionId = LoanTab.TransId INNER JOIN

UserTab ON LoanTab.BorrowerId = UserTab.Id
WHERE (UserTab.Name = &strUser& )

set rs = objConn.execute(sqlstr)

However this is the error i get:

Unterminated string constant
sqlstr = "SELECT LoanTab.TransId, ItemTab.Item, relationTab.Quantity FROM ItemTab INNER JOIN
--------------------------------------------------------------------------------------------^

__________________
Education ruined me

Hi,
       You have to concatenate statements which are on diffrent lines with "_" .
This is the corrcted statement.


sqlstr="SELECT LoanTab.TransId,ItemTab.Item,relationTab.Quantity" &_
"FROM ItemTab INNER JOIN" & _

"relationTab ON ItemTab.ItemId = relationTab.ItemId INNER JOIN" & _

"LoanTab ON relationTab.TransactionId = LoanTab.TransId INNER JOIN" &_

"UserTab ON LoanTab.BorrowerId = UserTab.Id" & _
"WHERE (UserTab.Name = '" & strUser & "')"

Thanks
Suresh