Hi,
Here's a tricky one! I have 5 very large databases that I am merging together via UNION SQL query. There are common records between the databases although one database may have the contacts "EmailAddress" and one database may not. When I use UNION it automatically deletes duplicate records, but the records are not exactly duplicate as in one databases there may be an empty field for a record that the other database has. Is there a way I can tell Access to ignore the empty fields and recognize when one row has exactly the same data as another (excluding empty fields) and deletes it? Is there any other way I can handle this?
Thank you!