How to create pie chart using multiple query dcounts

[behnam]

Hi,



i have 8 queries which run on a table called "trouble reports" I run 8 different queries and get the dcount of the totals, and store it into 8 global variables (R1-R8). How can i use these numbers to generate a pie chart using the numbers from R1-R8, thanks.

[ranman256]

Dont used dcounts. Use queries to sum the totals.
Attache the chart to the query.

[behnam]

Can u help me on the syntax, what would i write in the query wizard, for example how would i get the sum of a query called "all-exports" in the first column of the query wizard, and the sum of a query called "all-meters" in the second column.

[June7]

Do the queries have a common identifier field they can be joined on? Do the queries all have the same identifier values?

I analyze graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.