469,947 Members | 2,285 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,947 developers. It's quick & easy.

Totals In Crosstab Query

Tom
I have a report based on a crosstab query that shows monthly automobile sales.
The report is grouped on Make so that it shows the models under each Make. I
want to now get the subtotals by Make and then the total for all for each month.
I find that the control source for the textboxes in the detail section have a
date value such as Jan_03 rather than dollars but when I run the report dollars
appears in the report. Obviously I can't sum up dates. How do I get the subtotal
sales for each make and the toatal sales for all makes for each month?

Thanks for all help!

Tom
Nov 12 '05 #1
3 2668
DFS
Post your table structures and it will be easier to help you.
"Tom" <th*******@bellsouth.net> wrote in message
news:Bq***************@newsread2.news.atl.earthlin k.net...
I have a report based on a crosstab query that shows monthly automobile sales. The report is grouped on Make so that it shows the models under each Make. I want to now get the subtotals by Make and then the total for all for each month. I find that the control source for the textboxes in the detail section have a date value such as Jan_03 rather than dollars but when I run the report dollars appears in the report. Obviously I can't sum up dates. How do I get the subtotal sales for each make and the toatal sales for all makes for each month?

Thanks for all help!

Tom

Nov 12 '05 #2
Tom
Thank you for responding!

Here is my crosstab query the report is based on:

Model Row Heading GroupBy
Make Row Heading GroupBy
Expr1:Format([SaleDate],"mmm-yy") Column Heading GroupBy
SalesDollar:Sum(AutoSales) Value Expression

I have Grouping by Make with a Group Header And Footer.

The report comes out correctly where each Make is grouped and the models are
listed under their respective Make. The first field in the detail section was
assigned a name by Access of Jan_03 and shows unbound in design view. I want to
get the subtotal for each Make and an over all total for each month.

Thanks!

Tom
"DFS" <no******@nospam.com> wrote in message
news:vt************@corp.supernews.com...
Post your table structures and it will be easier to help you.
"Tom" <th*******@bellsouth.net> wrote in message
news:Bq***************@newsread2.news.atl.earthlin k.net...
I have a report based on a crosstab query that shows monthly automobile

sales.
The report is grouped on Make so that it shows the models under each Make.

I
want to now get the subtotals by Make and then the total for all for each

month.
I find that the control source for the textboxes in the detail section

have a
date value such as Jan_03 rather than dollars but when I run the report

dollars
appears in the report. Obviously I can't sum up dates. How do I get the

subtotal
sales for each make and the toatal sales for all makes for each month?

Thanks for all help!

Tom


Nov 12 '05 #3
DFS
Tom,

Again, post your table structures and it will be easier to help you.


"Tom" <th*******@bellsouth.net> wrote in message
news:Hl****************@newsread2.news.atl.earthli nk.net...
Thank you for responding!

Here is my crosstab query the report is based on:

Model Row Heading GroupBy
Make Row Heading GroupBy
Expr1:Format([SaleDate],"mmm-yy") Column Heading GroupBy
SalesDollar:Sum(AutoSales) Value Expression

I have Grouping by Make with a Group Header And Footer.

The report comes out correctly where each Make is grouped and the models are listed under their respective Make. The first field in the detail section was assigned a name by Access of Jan_03 and shows unbound in design view. I want to get the subtotal for each Make and an over all total for each month.

Thanks!

Tom
"DFS" <no******@nospam.com> wrote in message
news:vt************@corp.supernews.com...
Post your table structures and it will be easier to help you.
"Tom" <th*******@bellsouth.net> wrote in message
news:Bq***************@newsread2.news.atl.earthlin k.net...
I have a report based on a crosstab query that shows monthly
automobile sales.
The report is grouped on Make so that it shows the models under each
Make. I
want to now get the subtotals by Make and then the total for all for
each month.
I find that the control source for the textboxes in the detail section

have a
date value such as Jan_03 rather than dollars but when I run the
report dollars
appears in the report. Obviously I can't sum up dates. How do I get
the subtotal
sales for each make and the toatal sales for all makes for each month?

Thanks for all help!

Tom



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by Sherman H. | last post: by
4 posts views Thread by Judy | last post: by
3 posts views Thread by Jim Andersen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.