How can I pass the date params from Access to Excel chart 2

[Pack10]

I have an automated routine that takes a query from Access and passes it to Excel and formulates a graph. Works fine. The data is based on a date range, how can I get the date params from the Access report form into the header of the Excel chart....

 

[SkipVought]

hi,

How is the date range determined?

Is it arbitrary? In other words, can someone say, "Hmmmm? Yesterday I ran this for Feb thru Jun 1942, but today I'm gonna pick Dec 1960 thru Nov 2008, just for grins!"

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Pack10]

Hi
The date range is user selected. They have from to fields to enter.
It is usually month to date, month, last month, this quarter, last quarter... or they can enter two dates for a range.

 

[SkipVought]

Why not have the user run the application from Excel, since that's where the final result is?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Have you considered changing the SQL property of the saved query?

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

Hi

Can you elaborate on the changing the SQL property of the saved query.
I want those from/to dates to appear on the report in excel.

thx

 

[SkipVought]

If you can derive the date range from the query resultset, it is a simple matter of a formula in a cell to display that date range in prose, and then a textbox in your chart to reference the cell containg the date range in prose.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

To learn how to change the SQL property check out faq701-7433

Duane
Hook'D on Access
MS Access MVP