Crosstab Report - Dynamic Headings (1 Viewer)

FrostByte

Registered User.
Local time
Today, 13:38
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
Today, 06:38
Joined
Oct 29, 2018
Messages
21,357
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