Good morning,

Here is the situation: Have a column of credit card transactions that lists employee names and charge amounts a.k.a debits. In the same column it also lists employee names with an equal negative amount which shows a credit to the account.

What I am trying to do is to find the employee name and charge amount. Then cycle through the list and find the corresponding negative amount.

```
For example: 
John Doe, $100 
Jane Doe, $200 
Sam Smith, $300 
John Doe, -$100

```

When you run this module your results should return the names of Jane Doe and Sam Smith because only the records for John Doe had both a positive and negative value.

I have gotten very close to an answer but the solution falls apart when there are duplicate values.

```
For example: 

John Doe, $100 
John Doe, $100 
John Doe, -$100

```

In this solution the result should be John Doe, $100

So far I have tried with Access, VBA, and SQL but have not come up with an answer. 

For the solution, I don't really care if it means adding another object such as a table or a query to perform the comparison part. In the end I need to see a list of matched and unmatched employee names and values.

Additionally, I thought about adding on a column to my table that has a Boolean logic to show the two "matched" records as this will be a database and we don't necessarily want to delete the matched rows from the table master.

Thanks in advance!