I
Irishimp23
I have a query with a date field, an employee field, and a score field. In
the criteria for the employee field I have [Enter Employee Name]. I then made
a graph (chart) consisting of the date by month and the score.
When an employee's name is typed into the dialogue box it brings up the
graph with all of the individual employee's scores entered to date. However,
there is no identifiable employee name on the chart to know whose scores are
being displayed. I tried to make a graph with all three fields of the query
including the employee name and it gives me this error (The Microsoft Jet
database engine does not recognize <name> as a valid field name or
expression. (Error 3070) because of my specified criteria in the employee
field.
How can I get the graph to pull scores by individual employee and still
identify the employee on the graph?
Thanks,
Irishimp23
the criteria for the employee field I have [Enter Employee Name]. I then made
a graph (chart) consisting of the date by month and the score.
When an employee's name is typed into the dialogue box it brings up the
graph with all of the individual employee's scores entered to date. However,
there is no identifiable employee name on the chart to know whose scores are
being displayed. I tried to make a graph with all three fields of the query
including the employee name and it gives me this error (The Microsoft Jet
database engine does not recognize <name> as a valid field name or
expression. (Error 3070) because of my specified criteria in the employee
field.
How can I get the graph to pull scores by individual employee and still
identify the employee on the graph?
Thanks,
Irishimp23