I’m having trouble with the following statement:
CurrentDb.Execute “INSERT INTO tblOT SELECT tblOTemp.* FROM tblOTemp”
The attached pic shows that tblOTemp has 13 records in it but tblOT behind it shows that only 6 (in this case) have been copied over.
Any Ideas anyone? On other occasions I have had all, 1, 2, 4 records copied over but it should be a consistent 13 (employees).