If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Update Query
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, Chuck |
Thread Tools | |
Display Modes | |
|
|