I have two Access database tables containing place names.
Table A contains 30,000 places and Table B contains 25,000 places.
How can I end up with Table C that only contains the 5,000 places that are in Table A but not in Table B?
In the SQL world, you'd run a SELECT query on the bigger table that outputs all the place names in table A for which a match cannot be found in B - something like:
This would form part of a query that puts the results in table c
Not sure if that will help but I have nothing in reach running Access right now! Hopefully there will be an Access guru along in a moment...