K
KyleAK
I am trying to create a simple line graph in Access which pulls three
columns of data from a query. The first column pulls the past 12
months of data, the next pulls the previous 12 months of data, etc.
The query that the graph is based upon is a rolling query, so every
month it changes. In the graph, is there any way to have each column's
title reflect the date range of the data it is referencing? So, for
example, since this is June 2006, and the first column pulls the
previous 12 months of data, is there a way to format that column to say
"Data from June 2005 to May 2006"?
I'm not quite sure if I need to put this in the query that generates
the graph using an AS statement and two Date variables for each column
of data that is pulled, or if there is an easier way.
Thanks!
columns of data from a query. The first column pulls the past 12
months of data, the next pulls the previous 12 months of data, etc.
The query that the graph is based upon is a rolling query, so every
month it changes. In the graph, is there any way to have each column's
title reflect the date range of the data it is referencing? So, for
example, since this is June 2006, and the first column pulls the
previous 12 months of data, is there a way to format that column to say
"Data from June 2005 to May 2006"?
I'm not quite sure if I need to put this in the query that generates
the graph using an AS statement and two Date variables for each column
of data that is pulled, or if there is an easier way.
Thanks!