Include last available date in graph

[AaronWestcott via AccessMonster.com]

I am trying to create a simple line graph with date as the x axis. That is
the easy part. What I would like is to know if anyone knows of a way to
ensure that the last available date is included on the axis lable? In other
words, if the dates are ascending from left to right I would like the last
date with data to have a label.

The only way I have been able to is to add blank rows to my table with dates
into the future to fake out the app.

 

[Duane Hookom]

You may be able to use the "TOP" argument in your graph's Row Source.

SELECT TOP 35 SomeDate, SomeValue
FROM SomeTable
ORDER BY SomeDate DESC;