Crosstab Report - Dynamic Headings

FrostByte

Registered User.
Local time
Today, 03:17
Joined
Jan 15, 2015
Messages
56
Hi,

I have a crosstab report that returns the last 3 months data and works perfectly.

The issue is that time old problem where my column heading are year/month and move each month

i.e July19, Aug19, Sep19 to Aug19, Sep19, Oct19 (when run in October).

How can I dynamically create these?

Cheers
 
Can you show us your SQL statement? If it's not possible using a saved query, you might have to use VBA.
 

Users who are viewing this thread

Back
Top Bottom