Query parameters, charts, and reports in Access 2007

  • Thread starter Thread starter Ary
  • Start date Start date
A

Ary

I've got a report I am trying to create, and in it, I want to display several
charts showing graphical data from the same source query as the report is
sourced from. The source query has one parameter: [Agent ID Number].

I am having tremendous difficulty in getting the report to load and display
all charts while only having to enter the parameter once. I am being asked to
enter the parameter once for the report itself and once each for each of my 8
charts - obviously too many times for comfort! I'd like to be able to enter
the parameter once for the report and have the charts reference the same
parameter, particularly since it is all coming from the same source query.

I'm new to Access 2007, and have never experienced the same problem in 2003.
The solutions I used for similar issues in 2003 no longer apply.

Does anyone have any advice for fixing or working around this issue?
 
I should specify, before I get trounced for using parameters - I tried to use
a form to enter my parameters instead of using the quick and dirty query
parameter. The problem, as I mentioned, is that I'm used to Access 2003 and
the code I've used to do that in the past no longer works on 2007.
 
What doesn't work the same regarding queries and form controls from Access
2003 to 2007? Parameter prompts in 2003 would have caused the same multiple
prompting issues.

--
Duane Hookom
Microsoft Access MVP


Ary said:
I should specify, before I get trounced for using parameters - I tried to use
a form to enter my parameters instead of using the quick and dirty query
parameter. The problem, as I mentioned, is that I'm used to Access 2003 and
the code I've used to do that in the past no longer works on 2007.

--
-Ary


Ary said:
I've got a report I am trying to create, and in it, I want to display several
charts showing graphical data from the same source query as the report is
sourced from. The source query has one parameter: [Agent ID Number].

I am having tremendous difficulty in getting the report to load and display
all charts while only having to enter the parameter once. I am being asked to
enter the parameter once for the report itself and once each for each of my 8
charts - obviously too many times for comfort! I'd like to be able to enter
the parameter once for the report and have the charts reference the same
parameter, particularly since it is all coming from the same source query.

I'm new to Access 2007, and have never experienced the same problem in 2003.
The solutions I used for similar issues in 2003 no longer apply.

Does anyone have any advice for fixing or working around this issue?
Click to expand...
Click to expand...
 
Back
Top