Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crosstab Report Dates
- Thread starter Hayton
- Start date
This was not precisely what you asked for (but I think it is better because the order is correct.
TRANSFORM Sum(MGIAllCombined.fin_debtor_amount) AS SumOffin_debtor_amount
SELECT MGIAllCombined.mat_number, Sum(MGIAllCombined.fin_debtor_amount) AS [Total Of fin_debtor_amount]
FROM MGIAllCombined
GROUP BY MGIAllCombined.mat_number
PIVOT Format([Month_End],"yyyy"
& Format([Month_End],"mm"
I hope this helps. Regards
Warwick
TRANSFORM Sum(MGIAllCombined.fin_debtor_amount) AS SumOffin_debtor_amount
SELECT MGIAllCombined.mat_number, Sum(MGIAllCombined.fin_debtor_amount) AS [Total Of fin_debtor_amount]
FROM MGIAllCombined
GROUP BY MGIAllCombined.mat_number
PIVOT Format([Month_End],"yyyy"
& Format([Month_End],"mm"I hope this helps. Regards
Warwick
- Status
Similar threads
- Locked
- Question
