Date from Query Into Chart Axis Label

[Mwhiterabbbit]

Hello,



I built a nice chart to count the number forms made by each of our 3 shifts based upon a time frame. However, I cannot find out how to show the date range on the chart.

The query has two sections
It has the date field with criteria

Between [Enter the start date:] And [Enter the end date:]

and the Shift field that only contains A,B, or C.

The chart row source line is this

SELECT shiftdate.shift, Count(shiftdate.Date) AS CountOfDate FROM shiftdate GROUP BY shiftdate.shift;

If I was to select a date from 1/1/14 to 7/2/14 how do I show this on the chart when I run the report?

Thank you for your help

[rpeare]

Are you asking how you show each day in that date range regardless of whether there is any activity or not? or are you just asking how you show the shiftdate on the X axis of a line/bar graph?

Or are you asking how do you add a label to your chart showing the date range it was run for?

If it's the latter, you can add two fields to your query

StartDate: [Enter the start date:]
EndDate: [Enter the end date:]

Then base your report on the query as well as the chart and put a text box on the report with the formula

="Report run for dates between " & [StartDate] & " and " & [EndDate]

actually putting the label on the chart (with chart controls) I don't think can be done (I've never tried but the charting object in ms access is very limited)

[June7]

It is possible to use code to set content of chart labels (title, axis) but is more complicated than rpeare's suggestion for a textbox on report. Example from my code to set Y axis label.

If Me!Metric = True Then
Me.gphWeight.Axes(xlValue, xlPrimary).AxisTitle.Text = "Unit Weight, kg/cu.cm"
Me.gphGradation.Axes(xlCategory, xlPrimary).AxisTitle.Text = "Sieve Size (mm)"
Me.gphITSdry.Axes(xlValue, xlPrimary).AxisTitle.Text = "ITS Dry, kg/cu.cm"
Me.gphITSsoak.Axes(xlValue, xlPrimary).AxisTitle.Text = "ITS Soaked, kg/cu.cm"
End If

Sorry, don't have any for chart title or X axis. But I think the X axis is xlCategory instead of xlPrimary.