Hi All, I have a small query in MS Access.
I have 2 tables 1.Test1 2.Stable The title column in Test1 table have few titles which are same as Title column in STable. I want to lookup the title in STable and update the Scolumn in Test1 Table with Yes or No. That is if the Title is present in STable then Scolumn in Test1 should be updated as yes or no. This is very urgent as i need to do a presentation. Please find attached the excel with the data. Appriciate your help in Advance. Thanks Prashanth --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Sexy.xls
Description: MS-Excel spreadsheet
