Recent content by Runey

Thanks again PAT. Once again you come to my rescue (well sort of :) ) You helped me out once before in case you don't remember. I was afraid the answer would be something like that :( Well it doesn't hurt to ask. In anticipation I have already started coding something along the lines of what...

I have two tables. They are a list of games for the Amiga. Around 5000 entries in each table. I need to look for each game from table one and see if it exists in table two. e.g. 20000 Leagues Under The Sea This game exists in table 2 but is spelled differently. e.g. 20,000 Legaues Under The...

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, Thanks for repsponding. Ooops I didn't cut and pastse the SQL statement properly. It's a basic one that goes like this SELECT * FROM [tblGames] ORDER [tblGames].Name But I think Pats hit it on the head. The Name field could very well have multiple entries that are the same. Can I order by...

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...