Multiple record Insert from 1 table to another

[majordog]

Hey All,
I have a table, that has three columns whose value must be derived from 3 other tables - In other words, Reg in Table A must be copied into the master table joined by the plate number which exists in both of them. The problem is there are multiple records to be updated. Can I do this? I got this far: (but Access just hangs there, when propmpted for the parameters, I just hit enter. What can I change to do this?)

UPDATE [Vehicles]
SET [Vehicles].RegiAirCare2001 =[Aircare_2001_Matched].[Registration]
WHERE [Aircare_2001_Matched].[LPRPlate] = [Vehicles].[LPRPlate]

 

[Zequel]

At first glance, this doesn't appear to be a correct join.
I would change your statement to:
Update Vehicles INNER JOIN RegiAirCare ON [Aircare_2001_Matched].[LPRPlate] = [Vehicles].[LPRPlate]
SET [Vehicles].RegiAirCare2001 =[Aircare_2001_Matched].[Registration]