Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Error Message

Status
Not open for further replies.

fredk

Technical User
Jul 26, 2001
708
US
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!!!
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top