Combining Queries

[Jimbo]

Query1 & Query2 I combine using Query3, but I want to have
one query is it possible?

Query1:

TRANSFORM Sum([Changing Data].[BANK BALANCE]) AS
[SumOfBANK BALANCE]
SELECT [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], IIf([PORTFOLIO]="consumer dda -
odp","CONSUMER DDA - OD",[PORTFOLIO]) AS PORT
FROM [Non-Changing Data] INNER JOIN [Changing Data] ON
[Non-Changing Data].[ARRANGEMENT KEY] = [Changing Data].
[ARRANGEMENT KEY]
WHERE ((([Changing Data].[AS OF DATE])=#7/31/2004#) AND
((IIf(='S','Non-Accrual',IIf([PYMT PDUE]='4+','4+
Payments',IIf([PYMT PDUE]='3','2-3 Payments',IIf([PYMT
PDUE]='2','2-3 Payments','f')))))<>"f"))
GROUP BY [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], IIf([PORTFOLIO]="consumer dda -
odp","CONSUMER DDA - OD",[PORTFOLIO])
PIVOT IIf(='S','Non-Accrual',IIf([PYMT PDUE]='4+','4+
Payments',IIf([PYMT PDUE]='3','2-3 Payments',IIf([PYMT
PDUE]='2','2-3 Payments','f'))));

Query2:

SELECT [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], IIf([PORTFOLIO]="consumer dda -
odp","CONSUMER DDA - OD",[PORTFOLIO]) AS PORT, Sum
([Changing Data].[BANK BALANCE]) AS [BANK BAL]
FROM [Non-Changing Data] INNER JOIN [Changing Data] ON
[Non-Changing Data].[ARRANGEMENT KEY] = [Changing Data].
[ARRANGEMENT KEY]
GROUP BY [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], IIf([PORTFOLIO]="consumer dda -
odp","CONSUMER DDA - OD",[PORTFOLIO])
HAVING ((([Changing Data].[AS OF DATE])=#7/31/2004#));

Query3:

SELECT Query2.[AS OF DATE], Query2.[LENDING ACTIVITY
GROUP], Query2.PORT, Query1.[2-3 Payments], Query1.[4+
Payments], Query1.[Non-Accrual], Query2.[BANK BAL]
FROM Query1 RIGHT JOIN Query2 ON Query1.PORT = Query2.PORT;