group totals

[pwicr]

I'm running a query that I want a grand total for as well as a group subtotal for the various groups within the results. I don't want a report as it is harder to filter etc for the person I am creating the query for. is there a way to get this result in datasheet view?

 

[plog]

I bet some masochist could spend a few hours building sub-queries and sub-sub-queries and then one master union table to get this just like you want it. So the answer is technically yes.

Most likely someone with that ability and knowledge would just use a report. Would ordering the in Access like you want, dumping it into Excel and then going through row by row adding totals and sub-totals where necessary work?

 

[crxftw]

Maybe Crosstab query helps you?