Report Error when pulling info from Crosstab Query

[AnAngelnside]

If I look at my crosstab query results... they looks fine...

When I go to look at my Report that I created using the wizard that pulls from that query I get the error message below...

The Microsoft jet database engine does not recognize ‘[tblassocdegrees-exhibitdata].STATUS’ as a valid field name or expression.

 

[Sohaila Taravati]

Did you set up your column headings? If not, go the the design mode of your crosstab query and the properties of the query and set up your cloumn headings. Remember they have to exactly match the name of your fields, otherwise, it won't work. I think that will solve your problem.

Sohaila

 

[Rich]

Delete any order by on the property sheet too.