Automate Hidding Columns in a Crosstab

  • Thread starter Thread starter Colin
  • Start date Start date
C

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
 
Perhaps an entry in the Criteria line of your query, which will limit your
data to the most recent 6 months?
 
Back
Top