Totals in Crosstab Query

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have a crosstab query with sales numbers as my values
and week ending dates as my column headers. FWIW, my row
headers are product descriptions. I'd like to have an
additional final column that is the sum of all of the
weeks sales data for each product description. Can this
be done? Any help on how to do this would be greatly
appreciated.

Thanks.
 
Sure. Include your sales field on the query grid a second time, set the
Total to Sum and leave it a Row Heading.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top