Problem with Charts

[Maloo]

I have created a report based upon a query. The report has nothing as the record source because I get duplicate chart data if I use a record source for the report.

The report contains 4 different charts (as subreports) based upon Project ID and Status using "where" criteria in the graph row source:

This gives me all Project Id's:

SELECT [ProjId],Count(*) AS [Count] FROM [Open Summary]GROUP BY [ProjId];

This gives me select Project ID:

SELECT [ProjId],Count(*) AS [Count] FROM [Open Summary] WHERE [Projid] Like "d*" GROUP BY [ProjId];

There are two other charts like the one above.

Here is the problem: I want to put a date prompt in the query in order to select data based upon certain dates (begin date and ending date). When I put this in the query and then open the report, I am prompted 4 times for the beginning and ending date.

How can I correct this so that I am prompted only one time instead of four?

 

[mary]

I had a similar problem. Try creating a form where you enter the dates, add a button to the form with the on click event procedure pointing to your chart.

Also, the query that underlies your chart needs to reference the date fields listed in the form. For Example, the criteria in the query may look like: between[forms]![newFormWhereDatesAreCHosen]![nameOfDateFieldOnForm]! and [forms]![newFormWhereDatesAreCHosen]![nameOfDateField2OnFOrm]

Hope this helps!
Mary