H
HelpMe!
My Append query is not working and i am not sure why... Here is my SQL
INSERT INTO tblContractPOTracking ( TrackingID )
SELECT tblDocTracking.TrackingID
FROM tblDocTracking
WHERE (((tblDocTracking.DocumentNumber)="5" Or
(tblDocTracking.DocumentNumber)="6" Or (tblDocTracking.DocumentNumber)="7"));
Please help!
INSERT INTO tblContractPOTracking ( TrackingID )
SELECT tblDocTracking.TrackingID
FROM tblDocTracking
WHERE (((tblDocTracking.DocumentNumber)="5" Or
(tblDocTracking.DocumentNumber)="6" Or (tblDocTracking.DocumentNumber)="7"));
Please help!