S
SOS
I keep getting this error message when I run an INSERT SQL in the program. I
tested it on the SQL wizard and it runs okay without any error message. I
even cut down the fields to two fields for testing but I still get this
message.I looked these two fields and couldn't find anything wrong with them.
I don't know what is wrong in the sql. Can anyone help me? Here is the SQL.
strSQL =" Insert into tblTemp (Ln,Fn) select qry_Name.Ln, qry_Name.fn From
qry_Name"
in the qry_Name, I did some IIF statement in some fields. In other words, I
created some new fields such as qry_name.sortdate which will manipulate
birhday from mm/dd/yy to yy/mm/dd.
Any suggestion?
Thanks.
--
tested it on the SQL wizard and it runs okay without any error message. I
even cut down the fields to two fields for testing but I still get this
message.I looked these two fields and couldn't find anything wrong with them.
I don't know what is wrong in the sql. Can anyone help me? Here is the SQL.
strSQL =" Insert into tblTemp (Ln,Fn) select qry_Name.Ln, qry_Name.fn From
qry_Name"
in the qry_Name, I did some IIF statement in some fields. In other words, I
created some new fields such as qry_name.sortdate which will manipulate
birhday from mm/dd/yy to yy/mm/dd.
Any suggestion?
Thanks.
--