outofpractice
Registered User.
- Local time
- Today, 06:23
- Joined
- May 10, 2011
- Messages
- 32
I have which I thought would be an ultra-simple matter that is turning into nothing but trouble - I'm under a time constraint and am getting to the point where I have to look for assistance - so thought there was no better place than this forum.
Basically I pulled some data into an access database so I can query it and get the results I want.
I have two Tables:
Table1:
ID
Email Address
Custom ID
Table2:
Custom ID
--------
What I want to do is a query that brings back ID, Email Address, and Custom ID from Table1 when [Table1].[Custom ID]<>[Table2].[Custom ID]
All I am getting is thousands upon thousands of duplicate records. I've tried everything I can think of at this point and don't know what else to try.
I even tried running a match macro in Excel to identify where there was a match so I could then just delete the records - but there is so much data that Excel just chokes and gives "Not Responding"
I know I'm probably overlooking something obvious - but any help would be appreciated.
Again - all I want to do is return all records from Table 1 where the Custom ID doesn't match the Custom ID on Table 2
Thanks for any assistance
Basically I pulled some data into an access database so I can query it and get the results I want.
I have two Tables:
Table1:
ID
Email Address
Custom ID
Table2:
Custom ID
--------
What I want to do is a query that brings back ID, Email Address, and Custom ID from Table1 when [Table1].[Custom ID]<>[Table2].[Custom ID]
All I am getting is thousands upon thousands of duplicate records. I've tried everything I can think of at this point and don't know what else to try.
I even tried running a match macro in Excel to identify where there was a match so I could then just delete the records - but there is so much data that Excel just chokes and gives "Not Responding"
I know I'm probably overlooking something obvious - but any help would be appreciated.
Again - all I want to do is return all records from Table 1 where the Custom ID doesn't match the Custom ID on Table 2
Thanks for any assistance