Crosstab Query Totals - Bottom

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

I have a cross tab query that contains row headings of
Customer Name, Column headings of week begin dates.

The query gives me the row total, but I really want a
total for each column (to provide weekly totals).

I can't use a pivot table because users are able to
create new week begin dates, and I have the query refresh
to display the new dates.

Hope this makes sense.
Bernie
 
If you want to display detail records and summary records in the same query
datasheet view, you will have to use a union query. This is true whether you
have a standard select query or a crosstab query. The standard way to
display column totals is in a report.
 
Back
Top