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