Hello:
I need to create a pie chart on a report. The piechart has it's row source as a query that I have attached. The problem I'm having is that the query has the data in a column and the datasheet for the graph apparently needs to have the data in a row. I've tried a crosstab query but it puts the data in individual rows and the chart only reads the first. Note the SQL behind the query.
Hopefully I'm just missing something simple here.
Thanks in advance. Hello:
I need to create a pie chart on a report. The piechart has it's row source as a query that I have attached. The problem I'm having is that the query has the data in a column and the datasheet for the graph apparently needs to have the data in a row. I've tried a crosstab query but it puts the data in individual rows and the chart only reads the first. Note the SQL behind the query.
Hopefully I'm just missing something simple here.
Thanks in advance.
I need to create a pie chart on a report. The piechart has it's row source as a query that I have attached. The problem I'm having is that the query has the data in a column and the datasheet for the graph apparently needs to have the data in a row. I've tried a crosstab query but it puts the data in individual rows and the chart only reads the first. Note the SQL behind the query.
Hopefully I'm just missing something simple here.
Thanks in advance. Hello:
I need to create a pie chart on a report. The piechart has it's row source as a query that I have attached. The problem I'm having is that the query has the data in a column and the datasheet for the graph apparently needs to have the data in a row. I've tried a crosstab query but it puts the data in individual rows and the chart only reads the first. Note the SQL behind the query.
Hopefully I'm just missing something simple here.
Thanks in advance.
