Crosstab query and report

Topic

New Reply

Hi,

I have a crosstab query to count the value (Agree, Disagree, NoResponse) in “Responds” field. Then I have a report based on the crosstab query, which have three text boxes for Agree, Disagree and NoResponse.

Based on the date range I input to generate the report, some time there’s no data at all for NoResponse. Then after I generate the report, I will get the error message: “The Microsoft Jet database engine does not recognize ‘NoResponse’ as a valid field name or expression.”

Any suggestion how to resolve this error?

Thanks in advance.

Reply | Quote

Replies

Have a look at this threadjust down the page a little.

Reply | Quote

Have a look at this threadjust down the page a little.

Thanks, this works.

Reply | Quote