Creating An Access Report To Group Payments Of Equal Amounts

[Probie Coder]

I am new to MS Access and need to do the following:

Write a report that groups payment of equal amounts for each vendor together.

Ignore the sign (positive or negative) of the amount. Ignore groups with
only one record. For each vendor show a group header containing the vendor
number and name.

For example if the GrossAmt is $100 in one record and the GrossAmt is $-100
in another record treat that as a match.

Any assistance would be greatly appreciated!

- Thomas

 

[Duane Hookom]

Sort/Group first on Vendor. The next Sort/Group can use the expression:
=Abs(GrossAmt)