Hi Guys,

I'm getting stuck with the syntax on this one:

strSQL = "SELECT tblPaidAmounts.PaidID, tblPaidAmounts.PaidDate, tblPaidAmounts.Branch, " & _
"tblPaidAmounts.Collect, tblPaidAmounts.Discount, [collect]-[discount] AS AfterDiscount, " & _
"tblPaidAmounts.ExpAmt, [AfterDiscount]-[expamt] AS AfterExpenses, tblPaidAmounts.DepositAmount, [afterexpenses]-[depositamount] AS Balance " & _
"FROM tblPaidAmounts INNER JOIN tblbranches AS Branch ON branch.branchid = tblpaidamounts.branch " & _
"WHERE tblpaidamounts.Branch = " & Branchid
"ORDER BY paiddate DESC"

So Branchid is a global variable (I think) or it comes from a table when the user logs into the database, trouble is I can't encapsulate the branchid with a another & or use " & _ as I keep on getting unterminated string errors???

OK before I get flamed, let me put in a brief explanation, I tried to delete this post but I couldn't.

I managed to sort it out, I should have put a space in between the quote marks.

So this one is correct:

strSQL = "SELECT tblPaidAmounts.PaidID, tblPaidAmounts.PaidDate, tblPaidAmounts.Branch, " & _
"tblPaidAmounts.Collect, tblPaidAmounts.Discount, [collect]-[discount] AS AfterDiscount, " & _
"tblPaidAmounts.ExpAmt, [AfterDiscount]-[expamt] AS AfterExpenses, tblPaidAmounts.DepositAmount, [afterexpenses]-[depositamount] AS Balance " & _
"FROM tblPaidAmounts INNER JOIN tblbranches AS Branch ON branch.branchid = tblpaidamounts.branch " & _
"WHERE tblpaidamounts.Branch = " & Branchid & " " & _
"ORDER BY paiddate DESC"

And then it works.

OK So flame away, sorry guys

Response.Write()...