Recent content by KenNJ

This is the SQL statement generated by Access for the query I entered. UPDATE tblLocations INNER JOIN tblCounties ON tblLocations.[LocCity] = tblCounties.[CntyCity] SET tblLocations.LocCnty = [tblCounties].[CntyName] WHERE ( ( [tblLocations].[LocCity] =...

Hi, all. First time here, and I have a problem I hope the forum can help me with. I have a table of project locations to which I've added a column for the county in which the site is located. I also have a table of Counties that includes County Name, City Name, and State ID. I'm trying to...