Cross Tab Query to be used for calculations

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cross tabg query 1
Display columns without data in cross tab query 4
Cross Tab Query...Help 4
Cross-Tab Query 2
Missing Row Field in Crosstab Query 1
Problem with criteria in cros tab query 2
How to make this cross tab query 3
Null values in a cross tab query 2

Top