I have a chart with a query data source. In the query, I have placed the following under the DATE: "Between[enter a beginning date] and [Enter an ending date]". The chart works perfectly. However, I would like to place the selected date range across the top of the chart in order for the user to see the date range the chart is associated with.
I have done the same with reports by adding this to the top: ="Between" & " " & [Enter a beginning date] & " " & "And" & " " & [Enter an ending date]. It displays the date range the user has selected. However, I can't do the same to the chart, as the chart report is unbound, only the chart itself is bound to the query.
Anyone have any suggestions?
I have done the same with reports by adding this to the top: ="Between" & " " & [Enter a beginning date] & " " & "And" & " " & [Enter an ending date]. It displays the date range the user has selected. However, I can't do the same to the chart, as the chart report is unbound, only the chart itself is bound to the query.
Anyone have any suggestions?