Query - issue with multiple queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I'm still having issue with the multiple queries. I tried
the suggetion the internet user gave me but I'm still
having issue where I can't get the result from table 4.
Any more suggesetion?? I posted the feedbacks from the
internet users below.

Thanks for the help...

Mike
I have four tables, Table1, Table2, Table3, and Table4.
I'm trying to create a query that will retrieve all the
data from all four tables, regardless of the tables that
have data or not, I need to have some results. An internet
user,Larry, suggested to use multiple queries as:

query 1 table1 and table2
query 2 query1 and table3
query 3 query2 and table4

Does anyone have any clue on what multiple queries are and
know how to implement them with the list noted above?
Click to expand...

Multiple queries are... just three Queries in your Query
design
window.

Open the Query design window, and add Table1 and Table2 to
the query
background. Select the Join line and make it an Outer
Join. Save this
query; Access will ask you for a name - call it Query1.

Now create another new Query. Add Query1 from the Queries
tab, and
Table3 from the Tables tab. Repeat the join process.

Now repeat the operation joining Query2 to Table4. Save
this under the
name Query3.

If you open Query3, you should see data from all four
tables.
 
I think you probably need to use a union query.
Especially if a table 4 does not have data. In an empty
table, there is nothing to join. You can use a union query
to display the data from all tables and you don't have to
join them, you just have to make sure that the number of
display fields are the same for all queries you use.

Miki
 
I'm still having issue with the multiple queries. I tried
the suggetion the internet user gave me but I'm still
having issue where I can't get the result from table 4.
Any more suggesetion?? I posted the feedbacks from the
internet users below.
Click to expand...

How are the tables related? What is the Primary Key of each table;
what relationships (if any) have you defined? Do you want to "join"
the records, side by side, to pull one group of fields from Table1 and
different fields from the other tables; or are all the tables the same
in terms of field types, and you want to string the data together "end
to end"? Could you post the actual names of the tables, and their
Primary Key and "foreign key" fields (the field that you link to in
the relationships window)?

You've asked this question several times, and gotten several (good)
answers; I think the problem is that nobody (including me) who's
answering has a clear idea of the structure of your database or
exactly what you're trying to accomplish.
 
Back
Top