benjamin.grimm
Registered User.
- Local time
- Yesterday, 18:14
- Joined
- Sep 3, 2013
- Messages
- 125
Hello 
i have a cross tab query,
In the columns i have the date and in the rows i have a country.
It sums up from a table the planned busses in the next months.
I have the following SQL
PIVOT Format([date],"mmm") In ("Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez");
How can i change the SQL, that it starts with the next months and not with January.
Greetz Benjamin
i have a cross tab query,
In the columns i have the date and in the rows i have a country.
It sums up from a table the planned busses in the next months.
I have the following SQL
PIVOT Format([date],"mmm") In ("Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez");
How can i change the SQL, that it starts with the next months and not with January.
Greetz Benjamin
