Help with Update Query

C

Chuck W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Update Query 2
Quick Parts / SharePoint Library Update 0
Append Crosstab Query to Existing Table 0
Embedded Excel into Word with Tables 0
Adding data to MS Access from csv file 0
How can I make the following query read-write rather than read-only? 1
Need Help with Macro Security 1
Query to display all related data from 4-level tree 4

Top