I am attempting to join two queries in Access and am having difficulties, anyone that could help would be appreciated. The querires are as follows:

SELECT [Actuals].[Fiscal Year], [Actuals].[Period], [Actuals].[Activity_Group], sum([Actuals].[Actual_ Amount]) AS Actual_Amt
FROM Actuals
GROUP BY [Actuals].[Fiscal Year], [Actuals].[Period], [Actuals].[Activity_Group];

SELECT Sum(IIf([Budget_Number]=1,[Budget_Amount],0)) AS Budget, Sum(IIf([Budget_Number]=2,[Budget_Amount],0)) AS Approved, Budget.Activity_Group, Budget.[Fiscal Year], Budget.Period
FROM Budget
GROUP BY Budget.Activity_Group, Budget.[Fiscal Year], Budget.Period;

Thanks,
Mike