A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Crosstab almost perfect



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2007, 04:05 AM posted to microsoft.public.access.queries
Blair
external usenet poster
 
Posts: 27
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.