Crosstab Query ---> Line Graph

[ginoitalo]

I have a Access Crosstab Query and it's the source to a Line Graph (using the 'insert chart' from access 2000)

I get the error: Too much data (among other errors in the same messagebox)

the crosstab is 12 columns and 12 rows
(doesn't seem too bad)


jan feb mar ....
company x 1 2 3
company y 4 5 6
...


Does anyone know what's wrong ?
Is this the best way to do a graph ?

 

[Darrylles]

Hi,

You specify 12 X 12 for the crosstab.

Are you sure? The crosstab is dynamic, i.e. you don't know what the crosstab will return, unless you check what data is currently in the table.

(The crosstab uses 'data' from specified fields as headers. Therefore if you have specified 'X' as a field to use, and you have 3,000,000 records, and there are 1,000,000 unique values in 'X' throughout those 3,000,000 records - you will get 1,000,000 headers/columns to display.)

Have you set a particular field data-type to some type of decimal rather than Integer?

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[ginoitalo]

>>You specify 12 X 12 for the crosstab.

I know it will only be 12 across because I'm grouping by months.

The query works perfectly, it's getting it into a line graph that's creating all the problems.

I'd like the graph to resemble:

        jan       feb    mar   ....
1000     .
900                .      *
.        *         *      .
.
0

                            * = milk
                            . = juice