N
Naz
Hi
I have a query (qry_CourseEvalutaionByTeam) that shows ratings (1-10) that
training courses have been given by different teams. I have a form
frm_CourseList that has a combo box that lets me choose the course that i
want to see the rating for by team, this combo box is the parameter for the
query. The query works fine.
What i'm trying to do is have a very basic bar chart in a report that shows
the course along the bottom and x bars for the teams showing the rating. But
when i create a chart using the wizard and run a command button from the form
to open the report i get the message
"The Microsoft Jet database engine does no recognise
'forms!frm_CourseList!eocCourse' as a valid field name or expression"...and a
blank chart......the form is open.
I can get the report to give me a tabular result and that works fine, its
the charting that doesn't. If it can't be done in a report in a form is
another viable option for me.
Thanks in advance for any help.
I have a query (qry_CourseEvalutaionByTeam) that shows ratings (1-10) that
training courses have been given by different teams. I have a form
frm_CourseList that has a combo box that lets me choose the course that i
want to see the rating for by team, this combo box is the parameter for the
query. The query works fine.
What i'm trying to do is have a very basic bar chart in a report that shows
the course along the bottom and x bars for the teams showing the rating. But
when i create a chart using the wizard and run a command button from the form
to open the report i get the message
"The Microsoft Jet database engine does no recognise
'forms!frm_CourseList!eocCourse' as a valid field name or expression"...and a
blank chart......the form is open.
I can get the report to give me a tabular result and that works fine, its
the charting that doesn't. If it can't be done in a report in a form is
another viable option for me.
Thanks in advance for any help.