dates not showing up in Chart report

[MW]

I have a report that makes a pie chart of errors over a specific period of time (user specifies these dates in the parameters when opening the report). The pie chart shows up correctly in the report, but when I add the fields for the start date and end date, they just show up as #Name? on the report, even though they are correct in the query that the report is based on.

Any suggestions?

Thanks

 

[boblarson]

What are you putting in the Control Source for the Text Boxes on the Report?

BL

 

[MW]

This expression from the query for the start date: expr1: [Enter First Date]; this for the end date:
expr2: [Enter 2nd Date]

Thanks for your help.

 

[boblarson]

Instead of using the dropdown box that sets the control source, try using the expression builder to select the field from the query.

It should show up as something like:

=[MyQueryName]![expr1]

MyQueryName is the name of your query that the report is based upon. The expr1 is the name of your expression in that query that has the parameter that is set by the user.

BL
hth

[This message has been edited by boblarson (edited 01-11-2002).]