Cross Tab Query to be used for calculations

  • Thread starter Thread starter Pulley.Matt
  • Start date Start date
P

Pulley.Matt

I'm trying to use a cross tab query to get a total amount of money for
a set of subgroup accounts.
Once I have these totals (One total for expenses and one total income)
I need to find the difference but the problem I keep running into is
that sometime I may have an income but no expenses. example below -

Group 1 (total amount income) 10,000
Group 1 (total amount expense) 8,000
Group 1 (total funds left) 2000

I can't find a way to get the 2000 using the crosstab query... anyhow
would be great...

Thanks
Matt
 
Back
Top