Hi
I'm trying to create a line graph from a query I have set up that selects data from particular dates. The problem I am having is that the legend displays every day of the week (e.g. mon, tue... sun) even if only 2 days worth of data are selected, in the query (and how I want it to look) the date format is (dd/mm/yy) and I only want the dates displayed in the legend for the criteria set.
This is driving me crazy as it seems so easy but Access is just being awkward!
Thanks
I'm trying to create a line graph from a query I have set up that selects data from particular dates. The problem I am having is that the legend displays every day of the week (e.g. mon, tue... sun) even if only 2 days worth of data are selected, in the query (and how I want it to look) the date format is (dd/mm/yy) and I only want the dates displayed in the legend for the criteria set.
This is driving me crazy as it seems so easy but Access is just being awkward!
Thanks
