To Include Count In Crosstab Query

My query

TRANSFORM Sum([Tbl-SKS].NET_BAL) AS SumOfNET_BAL
SELECT [Tbl-SKS].BRNCD, Sum([Tbl-SKS].NET_BAL) AS [Total Of NET_BAL]
FROM [Tbl-SKS]
GROUP BY [Tbl-SKS].BRNCD
PIVOT [Tbl-SKS].CATDESC;

I want to include another field [ACNO] in the same table that i want to
count beside my netbal field with the rest of grouping remain the same as
above.

Thanks

Hi Zyus,

Try the method shown in this KB article:

How to Create a Crosstab Query with Multiple Value Fields
http://support.microsoft.com/kb/209143/


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"zyus" wrote:

My query

TRANSFORM Sum([Tbl-SKS].NET_BAL) AS SumOfNET_BAL
SELECT [Tbl-SKS].BRNCD, Sum([Tbl-SKS].NET_BAL) AS [Total Of NET_BAL]
FROM [Tbl-SKS]
GROUP BY [Tbl-SKS].BRNCD
PIVOT [Tbl-SKS].CATDESC;

I want to include another field [ACNO] in the same table that i want to
count beside my netbal field with the rest of grouping remain the same as
above.

Thanks