crosstab works, but not in report

[Nydia]

I have a database that holds survey answers.

i created a crosstab query that will show me each question
and then how many management answered agree, disagree,
etc. when i run the query it's fine, but when I run the
report that i created from this crosstab query i get the
following message "microsoft jet database does not
recognize [strongly agree] as a valid field name or
expresion" It's giving me this because no one in the
survey answered strongly agree to any of the 13 question.
How do i do it so that if nobody selected agree or
disagree on the survey that it will just show 0 or
blank?? i tried doing the join relationship, but when i
do that i get an error message also.

any help is greatly appreciated

 

[Marshall Barton]

I have a database that holds survey answers.

i created a crosstab query that will show me each question
and then how many management answered agree, disagree,
etc. when i run the query it's fine, but when I run the
report that i created from this crosstab query i get the
following message "microsoft jet database does not
recognize [strongly agree] as a valid field name or
expresion" It's giving me this because no one in the
survey answered strongly agree to any of the 13 question.
How do i do it so that if nobody selected agree or
disagree on the survey that it will just show 0 or
blank?? i tried doing the join relationship, but when i
do that i get an error message also.

Go back to the query and set its Column Headings property to
the complete list (in the desired order) of the responses in
the data. This will both show columns that do not have any
data (as in your question) and not show data columns that
are left out of the headings list.

 

[nYDIA]

I DON'T GET THE SUGGESTION GIVEN. WHEN I GO TO THE FIELD
THAT IS COLUMN HEADINGS AND CLICK ON PROPERTY, WHERE DO I
PUT IN THE COMPLETE LIST. AND WHAT DO YOU MEAN COMPLETE
LIST TYPE AGREE; DISAGREE; NO ANSWER GIVEN??

-----Original Message-----

I have a database that holds survey answers.

i created a crosstab query that will show me each question
and then how many management answered agree, disagree,
etc. when i run the query it's fine, but when I run the
report that i created from this crosstab query i get the
following message "microsoft jet database does not
recognize [strongly agree] as a valid field name or
expresion" It's giving me this because no one in the
survey answered strongly agree to any of the 13 question.
How do i do it so that if nobody selected agree or
disagree on the survey that it will just show 0 or
blank?? i tried doing the join relationship, but when i
do that i get an error message also.

Go back to the query and set its Column Headings property to
the complete list (in the desired order) of the responses in
the data. This will both show columns that do not have any
data (as in your question) and not show data columns that
are left out of the headings list.

 

[Marshall Barton]

I DON'T GET THE SUGGESTION GIVEN. WHEN I GO TO THE FIELD
THAT IS COLUMN HEADINGS AND CLICK ON PROPERTY, WHERE DO I
PUT IN THE COMPLETE LIST. AND WHAT DO YOU MEAN COMPLETE
LIST TYPE AGREE; DISAGREE; NO ANSWER GIVEN??

Please don't shout, it's hard on my old eyes.

I think you went to a field's property sheet instead of the
query's property sheet. Just click in a blank area of the
top part of the query design window (where the table is) and
the query's property sheet should be displayed. The second
property in the list is Column Headings and you should set
it to the exact values in the data table fields.

If the field contains Agree, Disagree, etc, then you should
type:

"Disagree","Disagree", . . .

Ithe field contains 1, 2, etc, then that's what you should
type.
--
Marsh
MVP [MS Access]

-----Original Message-----

I have a database that holds survey answers.

i created a crosstab query that will show me each question
and then how many management answered agree, disagree,
etc. when i run the query it's fine, but when I run the
report that i created from this crosstab query i get the
following message "microsoft jet database does not
recognize [strongly agree] as a valid field name or
expresion" It's giving me this because no one in the
survey answered strongly agree to any of the 13 question.
How do i do it so that if nobody selected agree or
disagree on the survey that it will just show 0 or
blank?? i tried doing the join relationship, but when i
do that i get an error message also.

Go back to the query and set its Column Headings property to
the complete list (in the desired order) of the responses in
the data. This will both show columns that do not have any
data (as in your question) and not show data columns that
are left out of the headings list.