Search results

Can you give me a breakdown of how I go about entering the code for creating the update query. I simply want to update the very same field from 1 table to the other where fields are named exactly the same in both tables, using the Primary Key field as the common denominator which is available...

I don't want new records to be created though. I want fields within current records to be updated using the 'ID' which is available in both sets of tables as the common Primary Key.

Hi, I have two Access tables which I need to combine in to just one. Log1 is the main table which has had the relevant collumns added to correspond to the same collumns in Log2 so the import should be fairly easy to map the data from and too. I keep being referred to an Update Query but...