Copy data from one table.column to another

[hpl2001]

Hi:

I am trying to copy data from one table into existing rows in another table. Here is a sample structure:

Table1.LocId
.Date
.otherdata
.number (there is a value in this field)

Table2.LocId
.Date
.otherTableSpecificData
.number (currently null)

I want to copy the number field value from Table1 into the corresponding number field in table2 where Table1.LocID=Table2.LocID and Table1.Date=Table2.Date.

How is this done?

TIA.

Holly

 

[PHV]

UPDATE Table2 INNER JOIN Table1 ON Table2.LocId=Table1.LocId AND Table2.Date=Table1.Date
SET Table2.number=Table1.Number
WHERE Table2.number Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dinger2121]

You can try an update query. Below is a link to creating update queries from the Microsoft web site.

http://office.microsoft.com/en-us/access/HA100765271033.aspx

 

[hpl2001]

That great. Thanks for the help.

Holly