I have an MS Query that return some numbers for years like this;
Year 1 2 3 4 5
Dataset a b c d e
But when I change the query to display data for 2, 3, 4, 5, 6 I get the following error;
If I recreate the query from start it works but it adds and additional blank row in the table, but then if I refresh the query the blank row disappears. I assume it is this adding of the blank row that is causing the error. I have tried expanding the table to include a blank row but that doesn't work either.
Year 1 2 3 4 5
Dataset a b c d e
But when I change the query to display data for 2, 3, 4, 5, 6 I get the following error;
If I recreate the query from start it works but it adds and additional blank row in the table, but then if I refresh the query the blank row disappears. I assume it is this adding of the blank row that is causing the error. I have tried expanding the table to include a blank row but that doesn't work either.
