Graphing Data in Access

[TheJoker]

I am trying to create a graph comparing data from a year in the past to current day and graphing the results. I have tried to use a cross tab query but do not find it adequate in evaluating data.

 

[NICKTHEGREEK]

I beleive a crosstab query will be adequate. Are you comparing a day this year to the same day last year? If so, can you not set a where condition in the crosstab to only display either date() or date()-365. This will give you 2 rows, one with todays figures and one with last years figures. The graph can then be based on this query.

 

[TheJoker]

I tried the crosstab but ran into a problem because that particular question is a seven element array. When I build the query it does not let me use the header column values but will only allow another column to be used. As such, even though I can get the date span to work, the values are useless as they do not reflect the value in the header column.