Report grouping

[mtp]

My report shows check number, broker name, and the amount. If the same broker name, there will have the same check number. Example, my report shows 2 check number 3, and the broker name for these 2 checks are the same, but the amount are different. I want to group the check number so the amount calculate the sum of any check that have the same number. Please help! Thank you.

 

[ZanyJanie]

Create a totals query and use it as the record source for your report.

In the query, you should group by the Broker first, then group by the Check Number and finally Sum the Amount.

 

[mtp]

It's worked great. Thank you!