I have a couple of related tables.
I have a form based on those tables that provides parameter input to a select query.
I have a crosstab query based on the select query.
This all works. I can select the required parameter on the form and view the results in the crosstab query.
I used to have a report based on the crosstab query. This used to work. It doesn't any more, instead it reports: The MSO Access database engine does not recognize " as a valid field or expression.
I opened the form, selected a criteria for the parameter selection and then opened the report in design mode - all the data fields display the little green "tick" representing no data.
I went to the report wizard, selected the crosstab query to find no fields available!!
I selected manual design and found the fields available!!
Can someone give me some hints about finding the problem.
I have a form based on those tables that provides parameter input to a select query.
I have a crosstab query based on the select query.
This all works. I can select the required parameter on the form and view the results in the crosstab query.
I used to have a report based on the crosstab query. This used to work. It doesn't any more, instead it reports: The MSO Access database engine does not recognize " as a valid field or expression.
I opened the form, selected a criteria for the parameter selection and then opened the report in design mode - all the data fields display the little green "tick" representing no data.
I went to the report wizard, selected the crosstab query to find no fields available!!
I selected manual design and found the fields available!!
Can someone give me some hints about finding the problem.