trying to get matching data from my query to insert into an existing table, nothing happens it just sits there, any ideas?


INSERT INTO Transactions ( [Asset Number], [Location Name] )
SELECT Books.[Asset Number], Books.[Location Name]
FROM Books INNER JOIN Tabletest ON Books.[Asset Number] = Tabletest.[Asset Number]
WHERE (((Books.[Asset Number]) Is Not Null));

Are you sure the query finds records to insert? When you have this query in the query designer, select "Datasheet View" to see the records that will be inserted. Are there any?

The SELECT clause (which can be a SELECT SQL on its own) of the INSERT SQL will never return any row because of the contradictory conditions on the INNER JOIN and the WHERE clause. Thus, your INSERT SQL has nothing to append, ever.

Suggest you first try the SELECT Query/SQL only until the SELECT Query/SQL returns the rows as required and then use the SELECT SQL as part of your INSERT SQL.

Hint: Check your Access Help on LEFT JOIN / RIGHT JOIN operations.