Select Statement with Order By

[susand1]

Hi, I am very new with VB and had a nice select statement working, then realised I had to do an Order By and now it will not work.

I need to return a result set that is ordered by a id number.

Here is the statement that I have

AddTranRecords "SELECT tblTransactions.PDAID,tblTransactions.TransactionI D, tblTransactions.TransDate, tblTransactions.Branch, tblTransactions.Description, tblTransactions.Debit, tblTransactions.Credit, tblTransactions.Paid FROM tblLoan INNER JOIN tblTransactions ON tblLoan.PDAID = tblTransactions.PDAID WHERE tblLoan.CustID =" & Me.CustID & "ORDER BY tblTransactions.PDAID ASC"

It works fine without the order by, I am struggling to get my head around how the string is laid out.

Thanks

[iburyak]

Change

[PHP]Me.CustID & "ORDER BY tblTransactions.PDAID ASC"[/PHP]

to

[PHP]Me.CustID & " ORDER BY tblTransactions.PDAID ASC"[/PHP]

You need a space betwee CstID and ORDER BY.... :)

[susand1]

thank you - so simple I will watch that from now on.