INSERT INTO Temp
WHERE PROBILLS.IDNUMBER Not In (select IDNUMBER from [temp]);
How do I change the query above into VBA such that I can run it via the line below
DoCmd.RunSQL "QUERY HERE"
Thanks for help. I tried few ways and all gave me an error/not-working query.