I have an Access query that is based on a crosstab query. The query "breaks" whenever the columns in the crosstab query change. I have tried using asterisk, but I do not want all the columns in the crosstab query to appear in the result of the main query.
In the figure, tblMatrix is the result of a Crosstab query that I have written out to a table. I want the PartNumber and PubDateMonday to appear first, and I want the data in order by those fields. I then want the QtyReceived and Overdue expressions to appear. I do not want the row number to appear in the query output.