By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,327 Members | 2,661 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,327 IT Pros & Developers. It's quick & easy.

Access 2000 Chart/Graph

P: 2
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.
Sep 4 '08 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,627
Store the actual Prompt in a Calculated Field, then set the Control Source of a Text Box equal to this Field. Suppose you have a Parameter Prompt on a [LastName] Field in an Employees Table as such:
Expand|Select|Wrap|Line Numbers
  1. [Enter Last Name:]
Store the actual Return Value in a Calculated Field, [Last], in the Query, and reference this Field:
Expand|Select|Wrap|Line Numbers
  1. Last: [Enter Last Name:]
Sep 4 '08 #2

P: 2
Store the actual Prompt in a Calculated Field, then set the Control Source of a Text Box equal to this Field. Suppose you have a Parameter Prompt on a [LastName] Field in an Employees Table as such:
Expand|Select|Wrap|Line Numbers
  1. [Enter Last Name:]
Store the actual Return Value in a Calculated Field, [Last], in the Query, and reference this Field:
Expand|Select|Wrap|Line Numbers
  1. Last: [Enter Last Name:]
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
Sep 7 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.