Unanswered: have a problem with the left function in a join
UPDATE [All] INNER JOIN [tbl location] ON (Left([tbl location].[Name],5)=left([All].[Name],5)) SET [All].[Primary] = [tbl location].[primary];
It just stops after a bit when trying to update. I have two tables "tbl location" and "All" on tbl loacation.name i have some fields that I want to compare the first five letters of All.name where if the first five characters in all match to the first five in location it will join.
Stops after the first few ticks on the progress bar.