Search results

A weird question, maybe an impossible one. Is there a way do something like an intelligent string compare. What I have is two tables. I need to find all matching record in both tables based solely on the name. However it is very common for minor spelling errors and punctuation differences to...

Hi there, Hope someone can help I am opening a recordset like this, where strDatabase is an SQL Statement Set rstDatafile = dbDatafile.OpenRecordset(strDatabase, dbOpenSnapshot) SQL Statement =[tblName] ORDER [Name] It opens and everything is seemingly OK. However I then run a loop that...