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