To IrogSinta and All,
Here I go again.
I have received wonderful help form you. Thanks again.
The attached database contains Query "Qry_Count_Sum_Total" . The first step in this query is to pull sums from 11 tables. Each sum is the result of multiple calculations. The query gives me "Query is too Complex." Once I have “Qry_Count_Sum_Total” working I will need to use this result in an additional calculation specific to each of the “??_???_Count_Sum” queries. This calculation will be something like BS_Score: [Qry_01_BS_Count_Sum].[BS_
Total] for each of the eleven queries.
I look forward to your help.