Combine similar data in report

[pipoconanan45]

Good day everyone,


I made a form that the user can use to filter the report based on the Region(CAR, Ragion III, etc).


Is there a way to combine similar data?
Instead of displaying all the "CAR" (pic above) from the table it will display
CAR | 31 | 28 |

Thank you in advance.

[ranman256]

You need 2 queries....
Q1 to show the one above,
and Q2 to sum Q1.
just open them both.

[June7]

Alternatively, Q1 is report RecordSource and use report Sorting & Grouping features with aggregate calcs in group header/footer.