I am trying to create a chart that displays employee efficiency per month. I want to to be available on the employees record. So I created a query that retrieves the date, employee ID, rating and that works fine. but when I make the chart and I choose the efficiency query I get an error saying:
"The Microsoft Jet database engine does not recognize 'forms!Employees!EmployeeID' as a valid field name or expression."
My query is made so I can choose the individual employee to display, and that works fine when I run the query. However the chart doesn't seem to allow the use of fields to sort out individual employees.
Anyone know why this is happening? Or perhaps a different method to show one employee at a time.
Thanks.
"The Microsoft Jet database engine does not recognize 'forms!Employees!EmployeeID' as a valid field name or expression."
My query is made so I can choose the individual employee to display, and that works fine when I run the query. However the chart doesn't seem to allow the use of fields to sort out individual employees.
Anyone know why this is happening? Or perhaps a different method to show one employee at a time.
Thanks.
)
