Append Query (1 Viewer)

ms_access_00

Registered User.
Local time
Today, 11:32
Joined
Sep 20, 2012
Messages
14
I am trying to run an append query but I am having trouble with it. I am trying to append records from one table to another table. Only two records should append to the "FixedTable" but 6 records get appended - (3 records identical of each of the records from the "TestTable1).

See code below:

Code:
INSERT INTO FixedTable ( [Project Code], Itpl, [Due Date] )
SELECT TestTable1.Code, TestTable1.Itpl, TestTable1.[Due Date]
FROM FixedTable, TestTable1
WHERE (((TestTable1.[Due Date])>#11/1/2012# And (TestTable1.[Due Date])<#1/1/2013#));

Any ideas on what I am doing wrong?
 

Users who are viewing this thread

Top Bottom