[Resolvido] Alguém me !?!

[acid 0]

Oi Galera,Alguém sabe qual é o erro nessa desta linha SQL:("select Compl1, Desc1 from tblConstrucoes where Desc1 = ("Select Last(Desc1) from tblConstrucoes where Codigo = '" & txtCod.Text & "'" and Compl1 = ("Select Max(Compl1) from tblConstrucoes where Codigo = '" & txtcod.Text & "'))")Tah dando erro de sintaxe...Naum sei mais o que fazer!!!Help me!!!! :unsure:

[Veber 0]

("Select Compl1, Desc1 From tblConstrucoes Where Desc1 = (Select Last(Desc1) From tblConstrucoes Where Codigo = '" & txtCod.Text & "' And Compl1 = (Select Max(Compl1) From tblConstrucoes Where Codigo ='" & txtcod.Text & "'))")

[acid 0]

http://forum.imasters.com.br/public/style_emoticons/default/joia.gif

 

Brigadaum!!!!

 

Deu tcherto!!!

[danizinha 0]

'" & text & "'