The following recordset has worked well but there are a couple problems because I cannot isolate an exact match for a string:
"SELECT * FROM pages INNER JOIN productsubcategory ON productsubcategory.url = pages.Pageurl WHERE Category LIKE '%Adhesion%' AND SubCategory LIKE '%Pull Off Adhesion Tester%' GROUP BY productsubcategory.url ORDER BY productsubcategory.myorder ASC";
In the above recordset, it will bring in any in subcategory "Adhesion Tester". So it will pull in "Pull Off Adhesion Tester" (Good) and "Concrete Adhesion Tester" (not good)
Is there any way I can make the recordset look for a string EXACTLY equal to a string?
Any help would be gratefully received