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
|
|||
|
|||
Crosstab almost perfect
This is my sql
My crosstab has a total across the top, the total decreases as the count goes up in the column rows. I would like a sub total at the bottom that totals the columns and then a Grand total under that to total the number of nests started with. Hope I explained it right. Lets say shed 1 has a start total at the top of 100 nests as each day passes some nests are added to the column and subtracted from the 100 at the top so the top total keeps decreasing, but there are no totals at the bottom to give me the total of all the days and the grand total which in this case would always total 100. Thanks any help Blair TRANSFORM Count(QDailyWheplingReport2.[NEST #]) AS [The Value] SELECT QDailyWheplingReport2.[WHELPING DATE], Count(QDailyWheplingReport2.[NEST #]) AS [Total Of NEST #] FROM QDailyWheplingReport2 GROUP BY QDailyWheplingReport2.[WHELPING DATE] PIVOT QDailyWheplingReport2.[SHED #]; |
Thread Tools | |
Display Modes | |
|
|