Report w/chart using text input for critera

[lcline]

What I want to do is create a report with a bar chart. I want the user to be able to input a date range and have that data charted.

What I have done is create the query to pull the data and "hard coded" (between #8/01/02" and #8/30/02") the date critera in. I then created the report with the chart. I hit preview and everything works fine.

I now go back to my query make it dynamic by having it point to text boxes on an input form (between [txtbegin] and [txtend] for the begin and ending date. When I call the report, I get a message back that txtbegin is not recongized. It has something to do with the fact that the chart creates and uses crosstab query, but I don't know how to correct the problem.

Any help or direction will be greatly apprecaiated!
Lee

 

[Sohaila Taravati]

In your crosstab, did you set up your column heading?

 

[Rich]

You have to define the parameters as Date/Time in crosstabs, however I'm not sure if the chart will change dynamically on a report, you may have to use the form chart and print that

 

[lcline]

Thanks for the quick responses!

The way I created the report was to create a query that pulled did a calculation on two fields in the table. I grouped the calculation by machine number and shift. It is this query that I used the values of txtbegin and txtend. I then used design view in for the report and inserted a bar chart. I chose the above query for data values. The charting wizard created the cross tab query. I am not using the date in the chart. Only the calculation, Machine number and shift is in the chart. I did not change columnheaders and am not sure how to change them.

Could either of you give me a little direction to correcting the problem?
Thanks,
Lee