Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
ORDER BY
Hi EE
I have the following and a mental block
Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Not working where have I gone wrong. Any help appreiated
chestera
I have the following and a mental block
Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Not working where have I gone wrong. Any help appreiated
chestera
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,
pls try
pls try
Set rsBooked = CurrentDb.OpenRecordset("Select ID FROM tblBooked" & " ORDER BY [ID] ASC")
reason being there is no space for your joined string and that created an syntax error
>> Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
>> Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Why not simply:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY [ID] ASC"
or:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY 1"
/gustav
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY [ID] ASC"
or:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY 1"
/gustav
everyone is focusing on the SQL, except Rgonzo.
1. you have to define the SQL correctly, Rgonzo did this although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:
strSQL = "SELECT ID FROM tblBooked ORDER BY ID"
2. The second is that cannot open a recordset by setting a value to a string.
set rsBooked = currentdb.OpenRecordset(st
1. you have to define the SQL correctly, Rgonzo did this although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:
strSQL = "SELECT ID FROM tblBooked ORDER BY ID"
2. The second is that cannot open a recordset by setting a value to a string.
set rsBooked = currentdb.OpenRecordset(st
Premium Content
You need an Expert Office subscription to comment.Start Free Trial