I want to do a cross tab report query in Microsoft Access but error message says won't let me.
The error when I try to go through the wizard is shown in this image attachment.
I've also included the Microsoft Access database that contains the data and the final Excel report I'm trying to build as an example.
Basically working off the query: qDataCombined I want to build a report that shows whether or not a Tag (normalized in table: usgaaptags) is assigned to a company (normalized as table: usgaapcompanynames.
The structure is described in the Excel and basically just puts a 'y' for the value of that Company.
How would I build a Microsoft Access query that would look exactly like my Excel attachment from this MS Access database?
Why does the crosstab query doesn't work in this situation?