>Given that this works

>select crsB.category, orderby, jul,aug,sep,oct,nov,dec,Jan,Feb,Mar,apr,may,jun,FisYear ;
>	from rta_revenuecategories crsA;
>	inner join ( ;
>	select ;
>	sum(iif(month(receiveddate)=7,Amount,000000000000.00)) as jul, ;
>	sum(iif(month(receiveddate)=8,Amount,000000000000.00)) as aug, ;
>	sum(iif(month(receiveddate)=9,Amount,000000000000.00)) as sep, ;
>	sum(iif(month(receiveddate)=10,Amount,000000000000.00)) as oct, ;
>	sum(iif(month(receiveddate)=11,Amount,000000000000.00)) as nov, ;
>	sum(iif(month(receiveddate)=12,Amount,000000000000.00)) as dec, ;
>	sum(iif(month(receiveddate)=1,Amount,000000000000.00)) as Jan, ;
>	sum(iif(month(receiveddate)=2,Amount,000000000000.00)) as Feb, ;
>	sum(iif(month(receiveddate)=3,Amount,000000000000.00)) as Mar, ;
>	sum(iif(month(receiveddate)=4,Amount,000000000000.00)) as apr, ;
>	sum(iif(month(receiveddate)=5,Amount,000000000000.00)) as may, ;
>	sum(iif(month(receiveddate)=6,Amount,000000000000.00)) as jun, ;
>	FisYear, Category ;
>	from rta_revenues ;
>	group by FisYear, Category) crsB;
>	on crsA.Category = crsB.Category ;
>	order by FisYear, orderby ;
>	into cursor crsRpt

>suppose now we want to add a field to the result "fytotal" that will total all amounts for all categories within a single fisyear? I tried adding a
>sum(amount) as fyTotal and a GROUP BY fisyear to the outside select but that didn't work.

So, did you figure this out or need a little bit more help?

Re: Functions in a select Thread #1341594 Message #1341630