This is what I get when I just do a simple select query.
Expand|Select|Wrap|Line Numbers
- SELECT
- Wholesale_Rank_qry_2.OMNI_Number,
- Wholesale_Rank_qry_2.branch,
- Wholesale_Rank_qry_2.branch_name,
- Wholesale_Rank_qry_2.[Rank>],
- Wholesale_Rank_qry_2.[0to5Rank],
- Wholesale_Rank_qry_2.Star_Rating,
- Table_Rank_qry_2.[Rank>],
- Purchase_Rank_qry_2.[Rank>],
- CUSB_Rank_qry_2.[Rank>]
- 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;
[b]The number of columns in the two selected tables or queries of a union query do not match[/]
Expand|Select|Wrap|Line Numbers
- SELECT [OMNI_Number],[branch],[branch_name],[Rank>],[0to5Rank],[Star_Rating]
- FROM [Wholesale_Rank_qry_2]
- UNION ALL SELECT [Rank>]
- FROM [Table_Rank_qry_2];
- UNION ALL SELECT [Rank>]
- FROM [Purchase_Rank_qry_2];
Thanks for all your help and time
TCB