Access 2010 chart error - doesn't like criteria in query

[rxsims]

Hi -

I am trying to create a line chart in an Access 2010 report. I am currently getting the error "The Microsoft Access database engine does not recognize '[the criteria in the query]' as a valid field name or expression.

I am able to run a report off of this query so I know it works.

In the query I have summarized the data so there wouldn't be too much for the report query to crunch.

Thanks.

 

[dhookom]

Check the Row Source of the chart to see if it is a crosstab query. If it is, you must enter/select the data type of the parameters. Query->Parameters:

Duane
Hook'D on Access
MS Access MVP

 

[rxsims]

Hi dhookom - I didn't understand how to use parameters. Instead I recreated this line chart without using a query (I used the table as the record source) and the chart created without problems. it is only when I use a query a the record source where I have a problem.

 

[dhookom]

I mentioned Row Source but you didn't provide the SQL view of your Row Source. We can't see your application so you need to help us out. Please provide the Row Source property of the chart that create the error. If there is any other source queries, please provide their SQL views.

Duane
Hook'D on Access
MS Access MVP