[RESOLVED] SQL Statement

[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!!

[GaryMazzone]

You need to add a space infornt of the order 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

I´m so stupid, lol
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

[fmcpc]

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

[GaryMazzone]

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.