FYI
Here is MY SQL for the to append query
INSERT INTO EUREKAList ( [Item Number], [Item Title], Platform )
SELECT WeekEUREKA.Itemnumber, WeekEUREKA.Title, WeekEUREKA.Platform
FROM WeekEUREKA LEFT JOIN EUREKAList ON WeekEUREKA.Itemnumber = EUREKAList.[Item Number]
WHERE (((EUREKAList.[Item...