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???