CrossTab Report

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I have report based on a crosstab query. It sums items
for three categories...Simple, Moderate, and Complex. The
problem I'm having is - if there are no Complex records
(or any other category) I get an error stating "The
Microsoft Jet database engine does not recognize " as a
valid field name or expression" and the report will not
run. Is there any way around this?

Any suggestions are greatly appreciated!
 
Put your column name In the query parameter "column headings"

Ex.: "columns paramters" = "Simple","Moderate","Complex"

If there is no Moderate the column will print without any data.


FRED

----- Ann wrote: -----

I have report based on a crosstab query. It sums items
for three categories...Simple, Moderate, and Complex. The
problem I'm having is - if there are no Complex records
(or any other category) I get an error stating "The
Microsoft Jet database engine does not recognize " as a
valid field name or expression" and the report will not
run. Is there any way around this?

Any suggestions are greatly appreciated!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab report - handling Null fields 4
Using select and crosstab queries on one report 1
Report based on filtered crosstab 5
Report Error for certain Crosstab Query 2
Wizard crosstab report failure 1
Crosstab report - handling Null fields 2
Pass-through query for sub report 1
Problem with crosstab report 4

Back
Top