Unmatch in multiple tables
- Thread starter Gunit
- Start date
- Local time
- Today, 03:25
- Joined
- Jul 9, 2003
- Messages
- 17,512
The fact that you want to check for unmatched records would indicate to me that all of the tables were of the same format. If this is the case then there is something wrong with your design because it is very unlikely that a correctly designed DB would need multiple tables with exactly the same layout.
If each table is exactly the same, except that the data belongs to a different group then a better method would be to add an extra field to the table identifing the record group.
For example let say you had three tables to store addresses, (A common mistake) one table for customers addresses, another suppliers addresses and another staff member addresses. A better way and a more correct way would be to have one address table, and identify each address with an extra field. In a situation where you have a customer who is also a supplier then you would have a many to many relationship table.
And the benefit of constructing your database correctly is that when you want to find unmatched data it's all there in one nice easy to access table! And that is the answer, combine all your databases into one and you will find it quite easy to do.
If each table is exactly the same, except that the data belongs to a different group then a better method would be to add an extra field to the table identifing the record group.
For example let say you had three tables to store addresses, (A common mistake) one table for customers addresses, another suppliers addresses and another staff member addresses. A better way and a more correct way would be to have one address table, and identify each address with an extra field. In a situation where you have a customer who is also a supplier then you would have a many to many relationship table.
And the benefit of constructing your database correctly is that when you want to find unmatched data it's all there in one nice easy to access table! And that is the answer, combine all your databases into one and you will find it quite easy to do.
Perhaps I shouldn't ask broad questions. These tables exist for the convenience of "exporting capabilities" to construct a 50 page publication document. Each page in this publication consists of queried, specific, tabled information from 4 different source tables tied together by a common key. I have 9 different areas of a state I'm comparing and contrasting information on. In order to do this, I need to find out if there is a easy built in function/expression in Access that I can use to find unmatched "occupation titles" (unique) so I can highlight them in my publication. I'd rather not print out each table (9 of them) and visual do this.
- Local time
- Today, 03:25
- Joined
- Jul 9, 2003
- Messages
- 17,512
Have you tried the "Find unmached query wizard" ?
- Local time
- Today, 03:25
- Joined
- Jul 9, 2003
- Messages
- 17,512
I gather from you responses that you are not a beginner so I would guess you have tried this, but I still need to ask the question:-
Could you pull all the data together in to one query, and use the Unmatched wizard against that query?
Could you pull all the data together in to one query, and use the Unmatched wizard against that query?
I suppose that is an option. I have 9 different "make-table" queries. I will have to go back and modify them to include an "area" code so I can distinguish the different regions within the state then combine them into one table. Part of my project is developing an SOP and frankly, I'm trying to keep the process simple so the next person could just import new data, and run saved queries however it has turned out to be anything but simple. I was just fishing around to see if anyone had any good methods of accomplishing this type of task. Thanks!
Similar threads
