Kristenmanette
New Member
- Joined
- Mar 20, 2013
- Messages
- 5
I have a table that looks like this:
ID | EEID | DR | CR |
1 | 333 | 30 | |
2 | 333 | 50 | |
3 | 333 | 30 | |
4 | 333 | 30 | |
5 | 444 | 60 | |
6 | 444 | 60 | |
7 | 444 | 70 |
<COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY>
</TBODY>
ID is my primary key column and it autonumbers the records. EEID is a person, and there are many records per one person. DR is a debit entry for that person, CR is a credit entry for that person.
Is it possible to run one or both of the following queries?
1) A query that returns to me matching records(matching means where the debit equals the credit for a person). If the query ran on the above table, it should return to me records (beginning with ID number): 1, 3, 5, and 6. May get tricky because there can be multiple same-dollar value transactions per person-for example, person 333 has a couple $30 debits. THe query should "know" that record 1 matches to 3 and it shouldn't match 4 to 3. "First come first match".....
2)A query that returns to me the opposite of what I defined in 1). A query that returns to me UNMATCHED records. If run on the above table, the query should return to me records 2, 4, and 7.
THANKS IN ADVANCE!!!!!!!
Last edited: