Crosstab query help

[Blair]

I didn't get a response on this question, so I am wondering if I didn't
explain what I am tiring to do well enough, or is this not possible
Thanks Blair

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

This is my sql

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 #];

 

[KARL DEWEY]

Post a sample of your data. Post an example of what you want the output to
look like.

 

[Blair]

This is how it looks now and is what I want except
I want totals on the bottom

shed #'s 1 2 3 4 5 Total of
nest's

Date Born 75 100 85 95 60 415

4/19/06 2 3 1 5 11
4/20/06 5 5 10 20
4/21/06 10 3 10 23
4/22/06 5 7 1 15 28
4/23/06 3
3

Like This

shed #'s 1 2 3 4 5 Total of
nest's

Date Born 75 100 85 95 60 415

4/19/06 2 3 1 5 11
4/20/06 5 5 10 20
4/21/06 10 3 10 23
4/22/06 5 7 1 15 28
4/23/06 3
3

SubTotal 25 0 15 5 40 85

Total 100 100 100 100 100 500


If I can't get these totals in the query can you use this query
to create a report with the totals?

Thanks Blair

Post a sample of your data. Post an example of what you want the output
to
look like.

I didn't get a response on this question, so I am wondering if I didn't
explain what I am tiring to do well enough, or is this not possible
Thanks Blair

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

This is my sql

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 #];

 

[KARL DEWEY]

You can always put the data in a report. You may need to use a subreport for
the sub-total and totals.

This is how it looks now and is what I want except
I want totals on the bottom

shed #'s 1 2 3 4 5 Total of
nest's

Date Born 75 100 85 95 60 415

4/19/06 2 3 1 5 11
4/20/06 5 5 10 20
4/21/06 10 3 10 23
4/22/06 5 7 1 15 28
4/23/06 3
3

Like This

shed #'s 1 2 3 4 5 Total of
nest's

Date Born 75 100 85 95 60 415

4/19/06 2 3 1 5 11
4/20/06 5 5 10 20
4/21/06 10 3 10 23
4/22/06 5 7 1 15 28
4/23/06 3
3

SubTotal 25 0 15 5 40 85

Total 100 100 100 100 100 500


If I can't get these totals in the query can you use this query
to create a report with the totals?

Thanks Blair

Post a sample of your data. Post an example of what you want the output
to
look like.

I didn't get a response on this question, so I am wondering if I didn't
explain what I am tiring to do well enough, or is this not possible
Thanks Blair

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

This is my sql

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 #];