I have a crosstab query that I have created which basically is a rolling 12 months. For intstance, if I ran the query today the column headings would be May-01 through May-02. Next month if I run it, they will be Jun-01 through Jun-02. I would like to create a report from this query however, I do not want to hard-code in the sources since they will be changing every month. Is this possible to do? Any suggestions?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.