Calculate the sum of different field for different query

[MAJLI]

is there any possibility to do the sum for different fields in different query.
for example : query 1 has field 1
query 2 has field 2 etc

i want to calculate the sum of these fields for all query :
field1(query1)+field2(query2)+etc
thank in advance

 

[mfgf]

Do the queries have any data in common?

If so, you could modify the report to include a query with a tabular model that references the first 2 queries as tabular sets. Add a filter to the tabular model to join the tabular sets on the common data value, then add your calculation into the third query jou just created.

Just a thought...

MF.