Crosstab Missing Column in data error
https://msdn.microsoft.com/en-us/library/office/aa191550(v=office.11).aspx
How to Tame the Crosstab Missing Column Beast (and Get a Free Lunch)
This article may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist. To maintain the flow of the article, we’ve left these URLs in the text, but disabled the links.
Michael J. P. Watson
Crosstab queries are a powerful means of summarizing data. But they can sometimes lead to unexpected situations. Mike Watson looks at how you can ensure that your data-driven crosstab reports can work reliably. Along the way, he also shows how Access helps you out by ignoring unwanted data.
A classical tale: Near year’s end, the boss asks you to set up a report summarizing the sales statistics by quarter. He wants it by yesterday. You give it a little thought and, bingo, you think, “This is where I’ll use my first crosstab query!” A bit later you’ve created the crosstab, designed the report (see Figure 1), tested it, and–it works perfectly! The boss likes it, the report goes into the production system, and it’s distributed to all of the regional sales offices–and they love it, too! You’re a hero and modestly concur with the compliments and plaudits that rain down on you. Career prospects: very positive.