OnClick - DateAdd

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

Kirstie Adam

All,

I posted this a week or so ago, but no joy, am re-posting in the hope
someone can help........




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
 
-----Original Message-----
All,

I posted this a week or so ago, but no joy, am re-posting in the hope
someone can help........




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
Click to expand...
Hi Kirstie,

have you considered using spin buttons to
increment/decrement the date value in [StartDate]? Then
use the requery action to have the query recalculate. This
should update the chart.

Luck
Jonathan
 
Jonathan,

Sorry, but could you tell me what a spin button is?

Thanks,

Kirstie



Jonathan Parminte said:
-----Original Message-----
All,

I posted this a week or so ago, but no joy, am re-posting in the hope
someone can help........




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
Click to expand...
Hi Kirstie,

have you considered using spin buttons to
increment/decrement the date value in [StartDate]? Then
use the requery action to have the query recalculate. This
should update the chart.

Luck
Jonathan
Click to expand...
 
Back
Top