R
Rod
Hello,
I have a query that is successfully appending the records I want from one
table to another. I need to delete only the source records which were moved
to the target table. Here is my query:
INSERT INTO [tblCandidate-Test] ( CANDIDATE, AREA_CODE, [NUMBER],
INPUT_NUMBER, DNC, FOLLOWUP_NUMBER )
SELECT TOP 150 [tblRRD Output].Name, Left([tblRRD Output]![PhoneNumber],3)
AS AREA_CODE, [tblRRD Output].PhoneNumber, Right([tblRRD
Output]!PhoneNumber,7) AS INPUT_NUMBER, [tblRRD Output].DNC, "1" &
[PhoneNumber] AS FOLLOWUP_NUMBER
FROM [tblRRD Output]
WHERE ((([tblRRD Output].DNC)=False));
Any thoughts on how this query could be modified to meet the requirement?
Thanks much!
I have a query that is successfully appending the records I want from one
table to another. I need to delete only the source records which were moved
to the target table. Here is my query:
INSERT INTO [tblCandidate-Test] ( CANDIDATE, AREA_CODE, [NUMBER],
INPUT_NUMBER, DNC, FOLLOWUP_NUMBER )
SELECT TOP 150 [tblRRD Output].Name, Left([tblRRD Output]![PhoneNumber],3)
AS AREA_CODE, [tblRRD Output].PhoneNumber, Right([tblRRD
Output]!PhoneNumber,7) AS INPUT_NUMBER, [tblRRD Output].DNC, "1" &
[PhoneNumber] AS FOLLOWUP_NUMBER
FROM [tblRRD Output]
WHERE ((([tblRRD Output].DNC)=False));
Any thoughts on how this query could be modified to meet the requirement?
Thanks much!