MS Access 2000 - Query 2 Tables At Once

3165 Views 2 Replies 3 Participants Last post by djaburg, Jun 14, 2008

mikeiswayawesom

Discussion Starter · Jun 13, 2008

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

Save

Status: Not open for further replies.

1 - 3 of 3 Posts

CTSNKY

· #2 · Jun 13, 2008

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.

Save

djaburg

· #3 · Jun 14, 2008

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.

Save

1 - 3 of 3 Posts

Status: Not open for further replies.

Top Contributors this Month