 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2006Compare Tables
Hello, I am using MS-Access 2003. I have 2 tables. 1 table is from a previous db, the 2nd table I created. I want to compare the 2 tables for individuals, by lastname, & the display the lastnames. Is that possible??? If so, point me to some examples/samples... Thank you, Charles L. Phillips Charles You may mean something different by "compare the 2 tables for individuals" than I do. What do you mean? Are you saying you want to see which records in both tables have the same LastNames? If so, what will you do if you have two "Smith"s? Regards Jeff Boyce Microsoft Office/Access MVP > Hello, > I am using MS-Access 2003. [quoted text clipped - 6 lines] > > Charles L. Phillips Hello, Sorry I am not very good at explaining myself, but what you stated is exactly what I want. If I have 2 Smith's", I want to delete the Smith from the 1st table. Once I deleted ALL the names I do not need, I want to import them into the 2nd table (the 1 I created)... Thank you, Charles L. Phillips > Charles > [quoted text clipped - 19 lines] >> >> Charles L. Phillips Charles I may not have explained myself well. If you have two "Smith" entries, are you quite certain that they are duplicates, and not actually representing two different persons, each named "Smith"? You can use the new query wizard to find unmatched values between two tables. You could use this to find all the entries in Table1 that are not in Table2. Then you could write a query to append these (the first query's results) to Table2. Or am I still not understanding? Regards Jeff Boyce Microsoft Office/Access MVP > Hello, > Sorry I am not very good at explaining myself, but what you stated is [quoted text clipped - 30 lines] >>> >>> Charles L. Phillips Hello, Sounds good to me, I'll try it... Thank you, Charles L. Phillips > Charles > [quoted text clipped - 49 lines] >>>> >>>> Charles L. Phillips |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.