Report Error Message

[fredk]

I have a report with unbound text boxes that has its datasource as a crosstab query - When I try to run the report I get the following error:

The Microsoft Jet database engine does not recognize 'qryQrtrComp_Crosstab' as a valid field name or expression'

qryQrtrComp_Crosstab is the crosstab query that is the data source of the report.


I can not find where the error is in the report - Any ideas?


Thank you very much!!!

 

[JSD]

Hello

This happened to me before

I don't know why, but try taking out any criteria you may have in the query and then run the query. You might not get the result you want but I'll bet it runs (that's what worked with me anyway0. Also, If you've renamed the query or fields in the query, make sure you've re-established the new names in the report properties and grouping levels.

Jeremy

 

[fredk]

Thanks Jeremy. I finally got this to work by starting from scratch - I did get the error when I copied another report and tried to re-work it.

Thanks for the help!!

Fred