Taking a sum of three fields

[lieip]

I'm trying to take a sum of three fields from three different queries but when i run it it gives me an error stating that the query is too complex...what can i do?
I tried converting the 3 queries to a make table query and use the 3 fields from the the table that it produces and it works... the problem is that the table that it produces contains static data... i need the information from the orginal query which are dynamic data

 

[PaulCoop]

What is the SQL statement of this Query?

How are you applying the Joins?

Paul Cooper

 

[lieip]

the query is this:
SELECT [BurdenDollars]+[GandA]+[Profit] AS Total
FROM (qryBurdenDollars INNER JOIN qryGandA ON (qryBurdenDollars.LaborID = qryGandA.LaborID) AND (qryBurdenDollars.TypeOfChange = qryGandA.TypeOfChange) AND (qryBurdenDollars.DeptName = qryGandA.DeptName)) INNER JOIN qryProfit ON (qryGandA.LaborID = qryProfit.LaborID) AND (qryGandA.TypeOfChange = qryProfit.TypeOfChange) AND (qryGandA.DeptName = qryProfit.DeptName);


But even without the Inner Joins:
SELECT [BurdenDollars]+[GandA]+[Profit] AS Total
FROM qryBurdenDollars, qryGandA, qryProfit;


I'm still get the error message... the problem is that Access can't make a query using 3 other different query and i'm not sure as to how i can go around this...

 

[PaulCoop]

lieip in the part:

SELECT [BurdenDollars]+[GandA]+[Profit] ...

what are these fields? This should look more like:

SELECT [qryBurdenDollars]![fieldname]+[qryGandA]![fieldname]+[qryProfit]![fieldname] ...

substituting for "fieldname" the correct field you want from each of the relevant queries.

Paul Cooper

 

[tlbroadbent]

Check the following.

http://support.microsoft.com/support/kb/articles/q103/4/29.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.