of course
Code:
INSERT INTO Transactions ( [Asset Number], [Location Code] )
SELECT Books.[Asset Number], Books.[Location Code]
FROM Books INNER JOIN Tabletest ON Books.[Asset Number] = Tabletest.[Asset Number]
GROUP BY Books.[Asset Number], Books.[Location Code]
HAVING (((Count(Books.[Asset Number]))>1));
I also had issues where the append was trying to overwrite the primary key, so I deleted the primary keys as they were auto numbers and now I'm working to rebuild the relationships with the asset number as the unique identifier. (which I should have done in the first place)