I have worked with many crosstab queries over the years and never encountered what is happening the past two days. I've created several crosstabs--one, then two others copied from it. All were working, then all stopped letting me in. With each, when I attempt to go into the Design view, I get:
You must enter Group By in the Total row for a field that has Column Heading in the Crosstab row.
I did have Group By in that field, but it has been changed to "Expression." It won't let me in to change it. When I click OK on the error message, it closes the query. There is no option to view the SQL version.
But it is complicated further by the fact that I saw this on the original query yesterday and eventually somehow got it to let me in. I changed it back to Group By then, and it worked until today when it was changed again--not only in this query but in the ones I'd copied from it.
I don't know if it could be affecting this, but I have a second query pulling from this one, and updating a table, based on it. The second query still works--pulling the data from the bad query. But I want to change something in the bad query and can't do it.
What can I try?