General discussion

Locked

Creating a report from crosstab query?

By JeffDonofrio ·
I'm having a problem with a report that uses a crosstab query. For some reason it will not recognize the the crosstab query as the record source? I get the following error:
"The Microsoft Jet database engine does not recognize 'QueryName' as a valid field or expression". Any ideas would be appreciated.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating a report from crosstab query?

by Glenda Gable In reply to Creating a report from cr ...

Not really sure with the limited information provided.. but a stab in the dark :)

Make sure to run the Crosstab Query.. make sure it works correctly. I would create a new report from the "Report Wizard" and see if you can change that in Design to get what you want.

Or.. try checking to make sure an Expression you have on the report is allowed. The field with an expression may not be interacting with the query making the whole report not run.

Or.. make sure the "Record Source" underForm properties is set right, I have in the past put that information in the wrong field within properties and couldnt find out why b/c I didnt check the data source.

Send me an email or comment if you need more help.

Collapse -

Creating a report from crosstab query?

by JeffDonofrio In reply to Creating a report from cr ...

Poster rated this answer

Collapse -

Creating a report from crosstab query?

by JeffDonofrio In reply to Creating a report from cr ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums