isladogs
Access MVP / VIP
- Local time
- Today, 21:54
- Joined
- Jan 14, 2017
- Messages
- 19,390
Having looked at your example which contains a small sample of your data, I remain of the opinion that you need to do this 'manually'
Create a new empty table with all the fields you want from those 2 tables
Create a query with those 2 tables without a join. The correct terminology is a CARTESIAN join (thanks Doc man). You will get a huge number of records with every record in one table linked to every record in the other.
Now filter it for a particular string e.g Business
Next change it to an APPEND query to add the records to your new table.
Repeat for e.g. Product and then in turn with each possible string.
Be systematic. It will take a while to do them all.
Having said that you MAY be able to devise a procedure to loop through every possible word string, run the append query and repeat.
If so, start it running and go out for the day whilst you leave it to run.
When done, delete the original tables.
Create a new empty table with all the fields you want from those 2 tables
Create a query with those 2 tables without a join. The correct terminology is a CARTESIAN join (thanks Doc man). You will get a huge number of records with every record in one table linked to every record in the other.
Now filter it for a particular string e.g Business
Next change it to an APPEND query to add the records to your new table.
Repeat for e.g. Product and then in turn with each possible string.
Be systematic. It will take a while to do them all.
Having said that you MAY be able to devise a procedure to loop through every possible word string, run the append query and repeat.
If so, start it running and go out for the day whilst you leave it to run.
When done, delete the original tables.
