Author Topic: Multiple query calculation  (Read 489 times)

Offline tosty

  • Full Member
  • ***
  • Posts: 11
  • Forum Citizenship: +0/-0
Multiple query calculation
« on: 30 Aug 2006 05:36:38 am »
Hellow every1,

This is my question.

I have a list that will have 11 rows the top 5 and the rest grouped as a single row.  For this I have a list with the top 5 and their total figure. And for the rest I need to substract the total for the entire list minus the total for the top 5.

For example:
Query 1 (entire rows)                         
Row1     20
Row2     22
Row3     23
Row4     30
Row5     31
Row6     32
Row7     33
TOTAL1 191

Query 2 (Top 5)
Row1     33
Row2     32
Row3     31
Row4     30
Row5     23
TOTAL2 149

TOTAL1-TOTAL2 = 42

But I wasn´t able to mix those calculations (total1 - total2) because I have them in different queries.

Is there any way to make calculations with items from different queries...?

I´m working with Serie 7 but I will have Series 8 in a few days so I can use solutions on any version.

Thank´s to all....
« Last Edit: 30 Aug 2006 05:38:58 am by tosty »