Advice and directions requested (unmatched results)

[robinc1969]

I have a file built in Excel which I love that compares 2 separate lists to show the differences between the two. But, Excel is slow and almost stalls my PC.


I would like to do this in Access if possible. the results of the 2 lists SHOULD BE identical. I only want to "show" what is not identical.

I attempted in Access to use 2 tables (imported from Excel) to show the difference or "unmatch" between the two. I tried to use an "unmatched" query and changing on purpose one of the numbers to test the "unmatch"..... But, did not get any results back. it showed everything matched.

I want to include 1) journal number 2) amount 3) general ledger number to verify they do match, but only want the "unmatched" amount to be seen, leading me back to the journal number and amount that does not agree.

Any suggestions?

Basically:

List 1 List 2

journal G/L # Amount journal G/L # Amount
1 200-20 $200.00 1 200-20 $200.00
2 200-30 $100.00 2 200-30 $100.00
3 200-40 $ 50.00 3 200-10 $ 20.00

Result:
Journal 3 does not agree (journal number will always be the same, but other items could be input error).

I am not sure of the commands or formulas needed in Access.

[Gicu]

Open the unmatched query that the wizard build in design view and drag the G/L# from List 1 to the same field in List 2;repeat with the Amount field. Now double-click on these two new joins and select Option 2 (All records from List 1 and only matching from List2). One you do that you should have three parallel lines/(Left Outer Joins) from all three fields from List 1 with arrows pointing toward List 2. Finally double click the G/L# and Amount in List 2 and in the criteria row enter Is Null (similar to what you should already have for Journal). And now run the query.

Cheers,