473,573 Members | 2,950 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2811
DFS
Post your table structures and it will be easier to help you.
"Tom" <th*******@bell south.net> wrote in message
news:Bq******** *******@newsrea d2.news.atl.ear thlink.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******@nospa m.com> wrote in message
news:vt******** ****@corp.super news.com...
Post your table structures and it will be easier to help you.
"Tom" <th*******@bell south.net> wrote in message
news:Bq******** *******@newsrea d2.news.atl.ear thlink.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*******@bell south.net> wrote in message
news:Hl******** ********@newsre ad2.news.atl.ea rthlink.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******@nospa m.com> wrote in message
news:vt******** ****@corp.super news.com...
Post your table structures and it will be easier to help you.
"Tom" <th*******@bell south.net> wrote in message
news:Bq******** *******@newsrea d2.news.atl.ear thlink.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
17650
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to Create a Dynamic Crosstab Report PRODUCT :Microsoft Access PROD/VER:1.00 1.10 OPER/SYS:WINDOWS
2
3035
by: Sherman H. | last post by:
I have a few questions for crosstab and popup form questions: 1. I created a crosstab as follows: IT Financial Operation John 21 22 22 Mary 15 17 16 Joe 28 29 31 For some other...
4
8109
by: Judy | last post by:
I'm using Access 2003 and was wondering if it is possible to have a paramater selection within a crosstab query so that I wouldn't need to build a new table. I have a select query that I'm using to build the crosstab query from. In the select query I'm prompting for a specific quarter but when I go to run the crosstab it doesn't seem to...
3
2003
by: lorirobn | last post by:
Hello, I'm creating a one-page report that will display only total counts, no details. I want to examine the values of 2 fields on the source table, and add to appropriate counters accordingly. MattressSize can have 3 values, Condition can have 5 values. Therefore I have 15 unbound text boxes in the report's Footer section which have...
7
1902
by: newguy | last post by:
I am trying to get the totals of a table by client by type of income. This query will get what I am looking for with each unique combination as a row: SELECT Sales.Client, BillCode.Type, Sum(Sales.Amount) FROM Invoice_Details INNER JOIN BillCode ON Sales.BillCode = BillCode.id GROUP BY Client, Type;
6
2933
by: KashMarsh | last post by:
Trying to show running totals on a report, except it needs to show one total amount and values being subtracted from it. For example, the report shows a Total Inventory amount (TotInvAmt). And then amounts for each month for the orders like JanAmt, FebAmt, etc. I want to show under each month column the following: (TotInvAmt)-(JanAmt)=B ...
8
6070
by: Penny | last post by:
(Access 2003 Multiuser Split DB, Windows XP Pro) Hi All, I would really appreciate just some basic tips on how to make a Crosstab Form based on a Crosstab Query. The query always has the same number of records(generated from a table of predefined 'timeslots'). The number of columns(one for each Consultant) varies depending on how many of...
3
1782
by: Jim Andersen | last post by:
Hi, Am using robvolks crosstab-procedure to generate a crosstab query. I get this result: Total A B C juli 455 1 107 347 okt 83 1 9 73 aug 612 1 113 498 juni 451 1 108 342
4
6465
by: m.wanstall | last post by:
I have a crosstab query that compiles data for Months of the year. I have a stacked select query on top of that crosstab query that uses the latest 2 months data and exports it to a fixed length flat file. Ideally I would like to be able to just select the Last 2 Columns of the Crosstab query as inputs to the Select query WITHOUT having to go...
0
7686
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8009
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8198
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8060
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5580
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3730
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2194
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1296
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1036
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.