Creating An Access Report To Group Payments Of Equal Amounts

  • Thread starter Thread starter Probie Coder
  • Start date Start date
P

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
 
Sort/Group first on Vendor. The next Sort/Group can use the expression:
=Abs(GrossAmt)
 
Back
Top