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
data value for each column.
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?
fact there is a wizard for this purpose.
Read up on it and if you have more questions post back.
Hope this helps.
Fons
columns (Primary and Secondary), and there is only one-----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
data value for each column.
it in Access so I don't have to export, cut and paste, orThis is a pretty simple chart in Excel, but I want to do
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?