select sum quersy that shows more that just the sum

[meacho]

i have two select queries that i essentially want to be one, i have tried using a sub selecect query but it doest seems to work , it only shows the main select not the sub select

1

SELECT LNE_P3e_Activities.UID, Sum(Results_Cost_Next_Period_Activities.Planned_Cost) AS ["costing"]

FROM LNE_P3e_Activities INNER JOIN Results_Cost_Next_Period_Activities ON (LNE_P3e_Activities.Activity_ID = Results_Cost_Next_Period_Activities.Activity_ID) AND (LNE_P3e_Activities.Project_ID = Results_Cost_Next_Period_Activities.Project_ID)
GROUP BY LNE_P3e_Activities.UID;

this gives me the sum of the "Planned cost" for each "UID"

the second is

SELECT 
LNE_P3e_Activities.Territory, LNE_P3e_Activities.Project_ID, LNE_P3e_Activities.Activity_ID, LNE_P3e_Activities.Delivery_Year, LNE_P3e_Activities.UID, LNE_P3e_Activities.UID_Desc, LNE_P3e_Activities.OPCT, Results_Cost_Next_Period_Activities.Planned_Cost, Results_Cost_Next_Period_Activities.Budgeted_Cost, Results_Cost_Next_Period_Activities.Period, LNE_P3e_Activities.Activity_Status, LNE_P3e_Activities.Actual_Finish
FROM 
LNE_P3e_Activities INNER JOIN Results_Cost_Next_Period_Activities ON (LNE_P3e_Activities.Activity_ID = Results_Cost_Next_Period_Activities.Activity_ID) AND (LNE_P3e_Activities.Project_ID = Results_Cost_Next_Period_Activities.Project_ID)
WHERE 
(((LNE_P3e_Activities.Delivery_Year)="0708") AND ((Results_Cost_Next_Period_Activities.Period)=11));

this gives me a table containing all the data required but the "Planned costs" are not summed.

i tried this

SELECT LNE_P3e_Activities.UID AS Expr1, Sum(Results_Cost_Next_Period_Activities.Planned_Cost) AS ["costing"]

FROM
 (
SELECT LNE_P3e_Activities.Territory, LNE_P3e_Activities.Project_ID, LNE_P3e_Activities.Activity_ID, LNE_P3e_Activities.Delivery_Year, LNE_P3e_Activities.UID, LNE_P3e_Activities.UID_Desc, LNE_P3e_Activities.OPCT, Results_Cost_Next_Period_Activities.Planned_Cost, Results_Cost_Next_Period_Activities.Budgeted_Cost, Results_Cost_Next_Period_Activities.Period, LNE_P3e_Activities.Activity_Status, LNE_P3e_Activities.Actual_Finish
FROM LNE_P3e_Activities INNER JOIN Results_Cost_Next_Period_Activities ON (LNE_P3e_Activities.Activity_ID = Results_Cost_Next_Period_Activities.Activity_ID) AND (LNE_P3e_Activities.Project_ID = Results_Cost_Next_Period_Activities.Project_ID)
WHERE (((LNE_P3e_Activities.Delivery_Year)="0708") AND ((Results_Cost_Next_Period_Activities.Period)=11))

)
GROUP BY LNE_P3e_Activities.UID;

but this gives the same result as the first sql statement and doesn't show the extra bits in the sub query.

I haven't used sub queries before so i dont really know how this works.

if anyone can offer some help and or an explination it would be much appreciated

Thanks all