Tech Support Forum banner

MS Access 2000 - Query 2 Tables At Once

3165 Views 2 Replies 3 Participants Last post by  djaburg
Hello,

I work at a firm with about 60,000 issues broken up into two separate tables for two separate clients. The types of data in these two tables is the same but the fields have different names and the data is formatted in different ways. The one piece of information that if formatted the same in both is SS#. When documents come in I need to search through both tables using an index number (formatted differently in both but can search "any part of field" to get it) to find out where it should be filed. Some things appear in both databases others only in one. Is there a way I can query both of these simultaneously in order to save time? How? In other words, I want to do a parameter query and see all the results from both at once. What type of relationship would have to be created between the two tabes? I am so confused. :4-dontkno
Status
Not open for further replies.
1 - 3 of 3 Posts
Run three queries in all....one for each table (dumping the results into a newly-created table) and one against the results table you create from the first two.

Or create a new table using a query with just the common information, then use that table to extract the remaining data from their respective tables.
In the long run, would it not make more sense to invest the time to migrate the data in to one table to streamline the process of searching? Continually creating queries to compare data in two tables seems to be awfully inefficient. Just an idea.
1 - 3 of 3 Posts
Status
Not open for further replies.
Top