Results 1 to 2 of 2
2011-01-05, 14:39 #1
- Join Date
- Dec 2010
- Thanked 0 Times in 0 Posts
I'm wondering what would be the correct way to combined queries that have two columns that are different, but need to be added to the same report
Iím trying to link four tables together.
In one table I'm going to be using all the fields [Feild1],[Feild2],[Feild3],[feild4]
In the other 3 queries I would like to all a column and put one row of data from each other query's [Feild1],[Feild2],[Feild3],[feild4] adding [FieldA],FieldB]
This shows just a select query in access, putting the tables together
FROM CUSB_Rank_qry_2 RIGHT JOIN (Purchase_Rank_qry_2 RIGHT JOIN (Table_Rank_qry_2 RIGHT JOIN Wholesale_Rank_qry_2 ON Table_Rank_qry_2.OMNI_Number = Wholesale_Rank_qry_2.OMNI_Number) ON Purchase_Rank_qry_2.OMNI_Number = Wholesale_Rank_qry_2.OMNI_Number) ON CUSB_Rank_qry_2.OMNI_Number = Wholesale_Rank_qry_2.OMNI_Number; [/sql]
The main table with all the data in it is Wholesale_Rank_qry_2. <-This table will have all of the Wholesale_Rank fieldís populated.
Now the queries below will only have the rank field populated if they have a rank from there original table
Thanks for taking the time to help me learn more about what queries I can us
2011-01-05, 15:37 #2
- Join Date
- Jun 2002
- Mt Macedon, Victoria, Australia
- Thanked 45 Times in 44 Posts
I am not sure that I understand the problem, but I think the issue is that the last three queries mentioned only contain data for some of the records.
When you join tables (or queries) in a query you can specify the type of join. To see the options double click the line joining the tables in the query design grid.
For each of your joins you need to specify that you want all records from Wholesale_Rank_qry_2Regards