CrossTab Query: Specifying which columns to exclude from selection.

[accessaspire219]

I have a query built on top of a crosstab query. The query that feeds data to the crosstab query contains data for various months/quarters/years- new month/quarter/year will be added each month. In order to keep up with the newly added month/quarter/year I modified the SQL of the query on top of (after) the cross tab query to read SELECT MyCrossTabQuery1.*, etc
Now there are certain columns from this crosstab query(essentially coming from the query that feeds to the crosstab query) which I do not want to show in the query after the crosstab query.
Is there a way I can specify which columns to exclude from the query when using the SELECT QueryName.*, method?
Thanks.

 

[pbaldy]

No; you could simply not use them in the form/report the query supports.