Unanswered: How come I can't display a chart when the query run fine?
when I run the query manually, it works fine. But, when I create a chart by using the query, it doesn't works. The error is: "The Microsoft Jet database engine does not recognize '[Forms]![frmProdReport]![txtWed]' as a valid field name or expression." I have done it over and over but still no luck with it.
There are two queries, the first query is to obtain all of the specific data with criteria in it. The second query is just summing it up and use it as to display it on the chart.