Access Graph Help - Moving Date

Question

I would like to have a time graph where the beginning date would automatically change everyday. The graph would be for a time period of 5 years with the beginning date on the left and ending date on the right, all along the x-axis. In other words, the dates on the 5-year graph would be automatically updated every day. How can this be done?

Answer 1

OK, thanks, I had indeed misinterpreted your request. Try this in the Criteria row:

Between Date() And DateAdd("yyyy",5,Date())

Answer 2

Hans:

The starting date should be the current date (today's date) and the ending date should be 5 years out. As example, if one opened the graph today, the starting date would be 8/16/2013 and the ending date would be 8/16/2018.  When the chart is opened tomorrow, the starting date would be 8/17/2013 and the ending date would be 8/17/2018.

Does that help? 

Thanks,

Bill

Answer 3

Apparently I have misunderstood your question. What do you want to be the starting data and what should be the ending date?

Answer 4

Hans:

I followed exactly what you indicated in the date/time field in the Criteria row with no quotation marks other than what you had shown. 

I also entered the query in the Row Source of the chart.

The chart did not start at today's date and the total time frame was not 5 years. The chart did not change from what I originally had which started 1/1/2011 and was 8 years in length.

Any other suggestions?

Thank you

Bill

Answer 5

Create a query based on your data, with the following condition in the Criteria row of the relevant date/time field:

>=DateAdd("yyyy",-5,Date())

Use this query as Row Source for your chart.