Chart problems in reports

T

Tom

I am trying to create a sales report based on sales
figures from 2001 to present. These figures are monthly
percentages, so for every year I have 12 figures. I am
trying to create a line chart to represent the data
visually, but I am struggling as I can only select six
fields from my query (which means I can only get six
months of data). In my query, i have an individual
coloumn for each month from Jan 01 to present (so a total
of 33 fields to insert into the chart).

Is there anyway I can do this in Access?

Thanking you in advance!

Regards,
Tom
 
F

Fons Ponsioen

What you need is a table with two columns, one for date
(month) and one for Sales(amount).
Now you can graph the data.
Hope this helps.
Fons
 
T

Tom

Is it possible to do this? If so, how can I take a query
that has these fields as Coloumns (across the top) and
make them rows in a table? For instance, I have Apr, May,
June etc. along the top with a Sales figure below it. How
do I create a table that takes these column headings and
arranges them into one column entitled "Month"? e.g.

Month Sales Figure
Jan 1
Feb 1
Mar 1
Apr 1

Thanks for your help on this!
 
D

Duane Hookom

One or more replies in a new thread of the same question from the same
poster.
 
F

Fons Ponsioen

What other data is in your table. i.e. is this data tied
to a region or city, either way you could do it by
creating a few append querries. If you wish send me a
sample table and I could make some sample querries for you
fonsponsio at provider sbcglobal.net
Hope this helps.
Fons
 
Top