Crosstab Report - Dynamic Headings (1 Viewer)

FrostByte

Registered User.
Local time
Today, 01:37
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
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:37
Joined
Oct 29, 2018
Messages
21,358
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

Top Bottom