Help - Access!

1ddqd

Ok, so I have a simple (or so I thought) query I need to make.

I have 2 tables: April No Contact (~9000 records) and March No Contact (~65k records)

Each has 1 column: Number

I want to see all loans that exist in both April No Contact and March No Contact. I tried an Unmatched Query, but that didn't work, so I tried to build it in design, and that didn't work well either. Any tips?

Right now, in design, it looks like this:



I still can't find the duplicates when I manually search each table with what it claims exists between the two.

bigwah

On the line going from the tables, right click. There are three options, choose the one that only shows items if they are in both. And I'd probably show March and remove the Is Not Null.

1ddqd

Ok, changes made:



I told it I want option 3: Include ALL records from March No Contact and only those records from April No Contact where the joined fields are equal.

That, logically, should show only that which was No Contact in March but also are on the list for April?

bigwah

Yes. If it only exists on April, it wont show. If it only shows on March, it wont show.

mspencer

Try putting this into SQL view. Then change back to design view to see what it looks like. (I write all my Access queries in SQL.)

SELECT [April No Contact].[Loan Number] FROM [April No Contact] INNER JOIN [March No Contact] ON [April No Contact].[Loan Number] = [March No Contact].[Loan Number] GROUP BY [April No Contact].[Loan Number];

If you're sure that there are no duplicate or repeated loan numbers in either table, you can omit the "GROUP BY [April No Contact].[Loan Number]" part.