Hi,
I have written an append query using the query wizrd for a specific table, then convertedit into Vb.
I would now like to use that same append query but use variables for the table names, etc. Can anyone provide assistance in this matter?Code:DoCmd.RunSQL "INSERT INTO WUC ( WUC, DESCRIPTION ) SELECT NEWWUC.WUC AS Expr1, NEWWUC.DESCRIPTION AS Expr2 FROM NEWWUC"
Thanks
Hawg1