Query totalling both rows and columns

[raskew]

Hi -

Suffering severe brain-cramp today. Have two queries:

1) For a specified month, totals various home expense categories, e.g., Insurance, Utilities, etc..

2) For a specified month, totals payment method, e.g., cash, check, credit card, etc., for each expense category.

The problem -- combining the two so that I end up with both row and column totals.

Know I've done this in the past but at the moment it escapes me. All help appreciated.

Best wishes and thank-you: Bob

 

[Banana]

raskew,

This may be easier to do using a PivotTable. If we're going to do it in SQL, I imagine we need to have two subqueries, one grouping on month and other grouping on expense category, then join them together.

 

[raskew]

Hi -

Still fighting with this issue. Any chance someone could post some sample SQL.

Thanks in advance - Bob