Search results

Hi I have attached a file with sample data (i have included only few records) Please find the details below: Sheet 1 (Study) --> Table 1 Sheet 2 (Occupation) --> Table 2 Sheet 3 (Results) --> The end result I'm expecting. I have colored the matching words in red i.e. the records from the 2...

@The_Doc_Man: Thank you for your advice. But I'm still a beginner in this field and want to learn more. Thus I'm seeking the help from you guys.

@ Galaxiom: So this is the case the two records share a common substrings (one or two words) the length cannot be fixed. One word is not contained in the other as in it is two different combination of words which might have one or two common words. @ Galaxiom: Sorry I'm not experienced in...

Re: MS Access Combing tables without common columns @ridders: I work at an educational startup company where we are trying to form a crosswalk between the various occupations and various instructional programs. It’s an effort to consolidate the interests to applicable areas and also to find...

Re: MS Access Combing tables without common columns @Plog: Thanks a ton for the help. Will try it and let you know how it works.

Hi All, Thank you for this overwhelming response. I wasn't expecting it to be frank. And also thank you moderator or administrator whoever moved my thread to this appropriate header.

Re: MS Access Combing tables without common columns @Plog Hi Thanks for the reply. By combine I mean to say I want to JOIN them. I want to join the two tables into a single one. I can't do this by a simply INNER JOIN as I do not have primary/foreign keys in either of the tables. Currently...

Hi Guys, I'm new to MS Access. I need help with combing two tables (with no common columns) I want to combine two table based on matching keywords. Ex: "Agricultural Business and Management." with "Agricultural Workers" (because "Agricultural" is common word in both) or "Agricultural Business...