Hi,

Im trying to develop a a report and a chart based on the same select query. My problem is the database requests the date (the query paremeter) from the user numerous times before it can plot the graph. Is it possible to make chart that plots directly of the data in the report so I don't need to run the query twice? I would appreciate any help.

Thanks

Try using a text box for the date and using the text box as the parameter within the query.

Len