Automate Hidding Columns in a Crosstab

[Colin]

Hi

I currently have a crosstab query that will show
historical data summing the totals by customer over time.

The time format is as follows
200405 (May 2004)
200406 (June 2004)
200407 (July 2004)

etc.

I have about 30 months of data to date and when I run the
query I only want to show the latest 6 months worth of
data. Therefore each month I have to hide the 7th oldest
month before exporting the data into excel and saving it
to our server.

I would be grateful if anyone has any suggestions to
automate the hiding of the 7th oldest column either
programatically or otherwise.

Kind regards,

Colin

 

[MacDermott]

Perhaps an entry in the Criteria line of your query, which will limit your
data to the most recent 6 months?