Crosstab Query Totals - Bottom

[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

 

[Duane Hookom]

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.