Using graphs in Access

[lamaar]

I am running a report off a standatd Query which prompts the user to enter criteria (ie. name and week number). The report runs fine. If I try running the report with just a graph in it, the graph prompts the user twice (as thought he Query is being run twice) - does anybody know why this is or if anyone knows of a better way around this I would appreciate it.

Thanks Lamaar75@hotmail.com

 

[Lozere]

I'm afraid you have to redesign a few you application.
I suggest you to ceate a small Form with you two parameters as TextBox, let the user fill those two fields, click on a button. THen you could run the same report with embedded graph, replacing the parameters by a condition referencing the field on the form
Assumed the text box are named "Param_Name" and "Param_Date" and your form called "MyParamForm"
In your query in Design mode
erase the parameters,
put the following conditions on the Name field:
=Forms!MyParamForm!Param_Name
and Week field:
=Forms!MyParamForm!Param_Week

So yo let the report's query retrieves twice the "parameters" but with no further question to the user.

 

[GingerR]

if when you say 'when i run the report with just a graph in it'.... check the Record Source of the report--it should be empty, if all you have is a report embedded in the report. there is no reason for it to be there if you are not listing data on the report, and this could be the second place you're being prompted for parameters.

Lozere's suggestion is good if you have both the records and the chart on the same report, and also i'd suggest going this way anyhow cause people might get tired of typing in the same info over and over, plus that way there is more room for mistakes (typing the wrong thing). I always have a Report screen where users input criteria into text boxes, then they can hit a button to see a listing of records, or hit a button to see the chart reflecting the same parameters without having to enter the same criteria in again.

g

 

[lamaar]

Thanks for that, i'll get to work on it. Lamaar75@hotmail.com