p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Expert One-on-One Access Application Development (http://p2p.wrox.com/forumdisplay.php?f=131)
-   -   Totals vs Crosstab Query (http://p2p.wrox.com/showthread.php?t=19831)

tlwaltz October 13th, 2004 06:45 PM

Totals vs Crosstab Query
The author states in the 2nd sentence in the 1st paragraph on page 132 under Crosstab Queries:

"A totals query can give you a total for all the sales made by all salespersons, but if you want to see separate sales totals for each salesperson, you need a crosstab query."

If you create a totals query based on a table containing the following fields: OrderID, SalesPerson and Sales using the following fields in the totals query: SalesPerson (GroupBy) and Sales (Sum), the separate totals will be generated for each salesperson as a result of the Group By on the SalesPerson fields. This can be done with a totals query. You don't need a crosstab query to generate separate sales totals. Where am I going wrong here?

Terry Waltz

All times are GMT -4. The time now is 12:48 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.