Excel VBS SQL Code Problem

[brucel_SA]

Hi i am trying to get arecord back from the database specificly the last recort i am using this SQL code.

[VBA]

SQL = "Select [amt] from tblrecon]" & _
"Where [ID]= (Select Max[ID] From [tblrecon]"


[/VBA]

But i am getting an automation error

thank you

[Bob Phillips]

Bit difficult without the whole coide, but you might at least need another space

[vba]

SQL = "Select [amt] from tblrecon] " & _
"Where [ID]= (Select Max[ID] From [tblrecon]"
[/vba]

[anandbohra]

I found these brackets issue like opening is there closing is not there & so on

[VBA] SQL = "Select [amt] from tblrecon] " & _
"Where [ID]= (Select Max[ID] From [tblrecon]" [/VBA]

The corrected one as per me is
[VBA] SQL = "Select [amt] from tblrecon " & _
"Where [ID]= (Select Max[ID] From [tblrecon])"[/VBA]

[Bob Phillips]

oops missed the bracket