Recent content by bobp

Pat, thank you. I won't pursue this further. I know you have tried to help but I hjave not the slightest knowledge of how to use SQL in ACCESS and what you have provided is way above my head. I really don't understand. I will try and find someone who can work me through this, hands on, in a way...

Thank you but I'm afraid I must be doing something wrong. Using the instructions the command added all the information in one column but that is not what I want. I want the program to scan the data in the correct column of the source table and only where it is already in my destination column to...

OK, my apologies if I didn't express myself clearly, I am new to this. I am using an Access 2010 database. I have a main table with 10 fields in it. It is a table for storing information on chemicals and I have 2000 chemical records in it. Two of the columns (fields, that is right isn't it)...

Please can someone help me with this question. I have a table that I wish to update with information from another. Two fields are common to both tables. I want to check one field for matching data and where there is a match to update the second field