another SQL insert problem

[Bullsandbears123]

I'm trying to run this sql code, but I get an error

"Insert into tbl_Trade_Orders_allocated SELECT *," & Chr(34) & Now() & Chr(34) & " FROM tbl_Trade_Orders WHERE [Trade_group_ID]=" & intTrade_group_ID & ";"


"Run-time error '3352'
No destination field name in INSERT INTO STATEMENT ("4/4/2004 9:37AM")."

My table are identical except that the tbl_Trade_Orders_allocated table has an extra "timestamp" field at the very end. What going on, should this work?

I know I can change the code to include each value in the insert table, but that takes to long is there a better way that works?

 

[Bullsandbears123]

I figured this one out too!

I forgot the "as fieldname" part after the now().