Variable Graph Values

[Markie]

Hello

I have a report that returns the quantity of variouse products ordered, between dates. The operator chooses the from & to dates and the query refers to the form for these parameters. The order date is a calculated field built form the origional file name that is a field in an imported orders file.

ie file name aa021104.txt (field)

Order date Calculation returns date 04/11/02

Is it possible to have a graph driven by a similar (or the same) qurey. Can I have access build a graph using variable dates.

I cant get it to work.

Using the wizard I put quantity on the x, date on the y and product name in the series.

I keep getting an error

the Microsoft Jet database engine does not recognize [Forms]![frmReports] etc

Any help will help me keep my hair

Cheers MB

 

[3699wat]

I haven't done graphs lately, but recall this problem.You probably will avoid this problem by setting the criteria to the graph and not to the form bound to the graph. Open the graph's properties and set the criteria in the row source on the data tab. Clicking on the dots behind the row source will open a query. Go from there.
Let me know if you need more help. I will look into this later on today.
Marcel