repair command SQL

[haocaocu]

In MS Access 2003 I used this command SQL
Quote:
st = "insert into PTTQ(NamThang,Tongtaisan) select " & temp_date & " as NamThang" & _
",Sum(IIf([acctcd] In ('1'),[DNoCuoi],0)) AS Tongtaisan from CDHOA"
debug
Quote:
insert into PTTQ(NamThang,Tongtaisan) select 201006 as NamThang,Sum(IIf([acctcd] In ('1'),[DNoCuoi],0)) AS Tongtaisan from CDHOA


where are command SQL wrong?
Sorry,Because my english very bad

[RuralGuy]

Did you solve this issue or mark it solved by mistake?