i would like to ask for the sql statement to the output:
ITEM DESC Jan Feb Mar Apr ... Sep Total xxxxxxxxxx 999 999 999 999 ... 999 9,999
where "Jan" column is sum of all "x" items purchased on Jan, "Feb" column as sum of Feb purchases, and so on up to "Sep", and "Total" as the total from "Jan" to "Sep" (as in the case here). the numbers may/may not be formatted, and the period varies, depending on the range.
your help will be much appreciated.
thanks!Ü
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
