OnClick - DateAdd

[Kirstie Adam]

All,

I have a pivot chart that shows the location of all of our cars, and who
they belong too.
Eg. 22 cars in storage, 5 belong to North Region, 17 belong to South
Region
32 cars on road, 12 belong to North Region, 20 belong to South
Region

The pivotchart runs from a query, which has multiple date columns in them.
Each date column has the criteria >=[Start Date].

I want to be able to click the mouse, or a button, and automatically add one
day to this date. So if the user starts off entering 01/01/04, after
clicking the mouse, it diplays where all the vehicles were on 02/01/04. And
if they click again 03/01/04. And so on.

There are only ever two regions, "North" or "South", and only ever "Storage"
or "Road"

It is a column chart.

Any help is greatly appreciated, if you need more information, let me know.

Thanks

Kirstie