Access Charts/Graphs - Date Range Display

[TGG via AccessMonster.com]

I have an Access 2000 query that asks the user for the start date & end date
for a report or chart. In the Access report, I can display the start & end
dates entered in the query in the header of the report.

Problem: When I create a chart/graph using the same query, I am unable to
display the start & end dates in the chart per the date prompts in the query.

Any ideas on how I can display the date range in the chart/graph?

Thanks much.

 

[Duane Hookom]

Have you considered displaying the dates directly above or below the chart
control? How about making the text box backgrounds transparent and placing
them on top of the chart control?

 

[TGG via AccessMonster.com]

Thanks for the tip. I tried your ideas in my Access 2000 chart but always
get an error message : #name?. I do have the text boxes pointing to the
correct query field (Date). TGG

Have you considered displaying the dates directly above or below the chart
control? How about making the text box backgrounds transparent and placing
them on top of the chart control?

I have an Access 2000 query that asks the user for the start date & end date
for a report or chart. In the Access report, I can display the start & end

[quoted text clipped - 6 lines]

Thanks much.

 

[Duane Hookom]

What is the control souce of your text box? Is this a field name? Is the
field name a reserved word?

--
Duane Hookom
Microsoft Access MVP

Thanks for the tip. I tried your ideas in my Access 2000 chart but always
get an error message : #name?. I do have the text boxes pointing to the
correct query field (Date). TGG

Have you considered displaying the dates directly above or below the chart
control? How about making the text box backgrounds transparent and placing
them on top of the chart control?

I have an Access 2000 query that asks the user for the start date & end date
for a report or chart. In the Access report, I can display the start & end

[quoted text clipped - 6 lines]

Thanks much.