Recent content by jopu

Thanks KeithG! "SQL2 = "UPDATE tblImport inner join tblPeipponen On tblImport.Town=tblPeipponen.Town SET Peipponen = -1;" Works :D pbaldy: I had try that one earlier but returned an input box for "Town". I'm still in baby shoes when it comes to all bits and pieces of SQL clauses... learning...

Hi all! I'm trying to find a way how can I use a list (which I have currently stored in a table) in a SQL WHERE clause. What I mean is that I have this SQL clause which sets a check box if town name matches any of the 3 town names in the clause... SQL2 = "UPDATE tblImport SET Local = -1...