Group by two colunms but print total when either changes

[rainford]

How do you group by two columns and print a totals when
either of the column value changes. The problem I am having is that if declare a footer to sum the totals for each of the column when both change at the same time then line appears with the totals. I only want one sum.

 

[JohnLowell]

What type of columns are they?

You can concatenate the 2 columns as 1 group (i.e. =Col1 & Col2) and use a header and a footer.

Whenever either column changes, a sum will be shown.

 

[JohnLowell]

What type of columns are they?

You can concatenate the 2 columns as 1 group (i.e. =Col1 & Col2) and use a header and a footer.

Whenever either column changes, a sum will be shown.

 

[rainford]

The two columns are strings. Where do you concat the two
columns in the query or the sorting or grouping option in the report.

 

[JohnLowell]

In th esorting and Grouping option in the report.
Just make sure you craete it with an = at the beginning (=Col1 & Col2)

 

[rainford]

Thanks a lot it work