[RESOLVED] SQL Statement

Hi, i´ve a problem with a sql statement!!!

This is my statement:
strSQL2 = "SELECT ID,txamort,aamort FROM tbltx1987 where [ID]=" & Id
strSQL2 = strSQL2 & "order by aamort asc"

Gives me a sintaxe error '[ID]=1order by aamort asc'

I have a TextBox were i write the Id. The first string gives me all records with ID=Id, in this case 1.

Anyone can help me!!

You need to add a space infornt of the order by

Quote:

---

Originally Posted by fmcpc

Hi, i´ve a problem with a sql statement!!!

This is my statement:
strSQL2 = "SELECT ID,txamort,aamort FROM tbltx1987 where [ID]=" & Id
strSQL2 = strSQL2 & "order by aamort asc"

Gives me a sintaxe error '[ID]=1order by aamort asc'

I have a TextBox were i write the Id. The first string gives me all records with ID=Id, in this case 1.

Anyone can help me!!

---

Pleople you can close this thread:wave:

I´m so stupid, lol :afrog:
I´ve been all afternoon trying to find some examples, and no one helped me out because the problem was easier...


Try to find the changes i´ve done to my statement:

Bad statement:
strSQL2 = "SELECT ID,txamort,aamort FROM tbltx1987 where [ID]=" & Id
strSQL2 = strSQL2 & "order by aamort asc"

Good statement:
strSQL2 = "SELECT ID,txamort,aamort FROM tbltx1987 where [ID]=" & Id
strSQL2 = strSQL2 & " order by aamort asc"

I will wait for an answer with the solution of the problem if anyone can see:)

thanks for the quick answer, it was helpfull because i solved the problem 1 minute after i make this thread on forum :)

As I said in post #2 look at the second part of the SQL statement . In the first (Bad) post there is a missing space infront of the word order. In second (good) post there is a space.