If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
To Include Count In Crosstab Query
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 |
Thread Tools | |
Display Modes | |
|
|