redo unon to sum?

[ttuser4]

hi,
how can i redo this query:

SELECT Sum(EXPENSES.AMOUNT) AS TOT_EXPENSE
FROM EXPENSES
HAVING (((EXPENSES.ACCT_NUM)=[forms]![projects]![text19]))
UNION SELECT Sum(EXPINT.AMOUNT) AS TOT_EXPENSE
FROM EXPINT
HAVING (((EXPINT.ACCT_NUM)=[forms]![projects]![text19]));

so it would give me one total sum instead of two lines with sum from each select statement?

 

[PWise]

Select Sum(A.TOT_EXPENSE)
from(
SELECT Sum(EXPENSES.AMOUNT) AS TOT_EXPENSE
FROM EXPENSES
HAVING (((EXPENSES.ACCT_NUM)=forms!projects!text19))
UNION SELECT Sum(EXPINT.AMOUNT) AS TOT_EXPENSE
FROM EXPINT
HAVING (((EXPINT.ACCT_NUM)=forms!projects!text19))
)a

 

[ttuser4]

thanks