I hate queries - lol

[MisawaPlayer]

I know that what I have been asked to do is not that difficult. I am just stuck and can't figure it out. So I am sure the people here at Access World can help me.

I have 2 related tables:

Payments:
InvoiceNum
Date
PaidAmount (Note can be positive or negative amount)
VendorID - links to table Vendors
Other fields not important at this time.

Vendors:
VendorID
VendorName

I need to create a report that displays (grouped) all cases where the same PaidAmount (regardless of +/- so ABS) was paid to the same vendor, regardless of date or InvoiceNum.

I think I can figure out the grouping on the report, but I can't figure out what I am missing in terms of the query. Any help please.

To repeat, I need a query that will select basically Payments.*, Vendors.VendorName where the ABS(PaidAmount) is the same and VendorID is the same.

Thanks in advance.

 

[Alansidman]

Create a duplicates query using the Query Wizard. After the query has been generated, open it in design view. Change the paid amount field name to PaidAmount1: ABS([Paid Amount]) and see if that gives you the expected results.

 

[MisawaPlayer]

Thank you. I got myself so wrapped up in trying to write it from scratch that I forgot to take advantage of what Access has to offer.

Obviously, the query is returning exactly what I need now.