I have two tables of data from different sources. I want to create a new table that takes data from TableA and TableB only if a certain field in both tables match.
I’ve tried various queries but I’m a noob at Access (maybe this can be done in Excel, instead?). Can anyone help?
Thanks in advance.
Use the find duplicates wizard and then make the query a “make-table” query from any values that the find duplicates locates
In query builder view, have you tried linking the two fields that should match by dragging the mouse from one field to the other? This should create a link which governs the query results. Then just add the fields you want.