Chart problems in reports

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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
 
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!
 
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
 
Back
Top