I am trying to put a chart on a report based on a query that counts the number of records for a particular customer.

The query asks for a start date and finish date and then the report runs. If I put the chart on this report, based on the same query to show the results pictorially, then I get asked for the start and finish dates twice.

Is there any way I can avoid this duplication of input criteria?

Do you have controls displaying start date and finish date in the report? If you do, you can use them as parameters in the chart row source:

BETWEEN Reports!YourReport!StartDate AND Reports!YourReport!FinishDate

Yep, I'll try that - I think it is what I'm looking for! Thanks!

Ok, I was all set to put the code in that you suggested Luiz, but I already have this in my row source property - created when I use the chart wizard -

SELECT [DeptError],Sum([CountOfDeptError]) AS [SumOfCountOfDeptError] FROM [Rejections_ByDate_CountNCRs] GROUP BY [DeptError];

Do I have to modify this with what you've given me? I've tried replacing it but this doesn't work and I'm not sure how to combine the two.

HI there

I had this problem and I found the only way to resolve it was to go into the query and select Query>Parameters.. from the menu. In the box that pops up type each parameter that you are using oin a seperate line and specify it to be date/time so
e.g.

Parameter Data Type
[Chooose from date] Date/Time
[Choose to date] Date/time

Don't ask me why it works - it just does (for me anyhow)

Let me know how you get on!

Sara