Pie Chart giving me headaches

F

Fons Ponsioen

You would use a crosstab query for this. As a matter of
fact there is a wizard for this purpose.
Read up on it and if you have more questions post back.
Hope this helps.
Fons
-----Original Message-----
Hi

I am trying to create a pie chart which is only returning one value (one big pie).

The query that the chart is based on returns data in two
columns (Primary and Secondary), and there is only one
data value for each column.
This is a pretty simple chart in Excel, but I want to do
it in Access so I don't have to export, cut and paste, or
transpose data every two weeks. Is there a way to get
Access to read across the rows instead of down the
columns? If not, is there a way to write a query that
will transpose my data from rows into columns?
 
Top