From: Chuck W on
Hi,
I have a table called tblLocations that has fields such as LocationID
(autonumber) and UnitID (number). I also have a table called tblMonths1 that
has LocationID (number). I just created a field called UnitID. I want to
run an update query that will match the LocationIDs from the two tables and
then fill in the values for the newly created UnitID field in the tblMonths1
from tblLocations. Can someone help?

Thanks,