Query parameter

[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, and i
can get the chart to work with a fixed value in the query.....but its
the charting that doesn't work if i use the combo box to select the parameter.
If it can't be done in a report in a form is
another viable option for me.




Thanks in advance for any help.

 

[John Spencer]

Try declaring the parameter type

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
[Forms]![frm_CourseList]![eocCourse]
Select the data type of the parameter in column 2



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Naz]

WOW!!!!
That works...many thanks
--

_______________________
Naz,
London

Try declaring the parameter type

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
[Forms]![frm_CourseList]![eocCourse]
Select the data type of the parameter in column 2



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

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, and
i
can get the chart to work with a fixed value in the query.....but its
the charting that doesn't work if i use the combo box to select the
parameter.
If it can't be done in a report in a form is
another viable option for me.




Thanks in advance for any help.
--

_______________________
Naz,
London