Repeating Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created the database and am adding charts to my reports. I have a report that shows part failure qty by supplier by month. I set the parameter query to ask for Year and then Month. Works great. Then I add the Pie Chart and it asks for the each parameter 3 times before displaying. I have tried and retried, but to no avail. I am stumped. Please help!!
Thanks, Bryan
 
Don't use parameter/prompt queries. Get your input from controls on a form.

--
Duane Hookom
MS Access MVP


Bryan said:
I have created the database and am adding charts to my reports. I have a
Click to expand...
report that shows part failure qty by supplier by month. I set the
parameter query to ask for Year and then Month. Works great. Then I add
the Pie Chart and it asks for the each parameter 3 times before displaying.
I have tried and retried, but to no avail. I am stumped. Please help!!
 
I have created the database and am adding charts to my reports. I have a report that shows part failure qty by supplier by month. I set the parameter query to ask for Year and then Month. Works great. Then I add the Pie Chart and it asks for the each parameter 3 times before displaying. I have tried and retried, but to no avail. I am stumped. Please help!!
Thanks, Bryan
Click to expand...

One convenient way to do this is to use a Form to collect the
parameters. Create a small unbound form, name it frmCrit perhaps, with
controls (combo boxes are good for months and years!) named cboMonth
and cboYear. Instead of a criterion [Enter month:] use

=[Forms]![frmCrit]![cboMonth]

It would even be possible to put a command button on frmCrit to launch
your reports.
 
Back
Top