Updated Query

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

I'm trying to figure it out. In the table, some of the information in blanks. I have another table that I would like to update some fields in the table .

Example:

**(Table A - Completed data)
Record ID (Primary Key)
Last Name
First Name
Home Address
State
Country


**(Table B- Not Completed Data)
Record ID (Primary Key)
Last Name (blank)-I want to collect Last Name from Table A)
First Name
Home Address
State (blank)- I want to collect State from Table A)
Country

Is there an query to update from Table A to B by selected fields?

Your help would be much appreciated.
 
Is there an query to update from Table A to B by selected fields?
Click to expand...

Certainly. Create a Query joining Table A to Table B by the Primary
Key. Change it to an Update query. Under each field that you want to
copy data *into*, on the Update To row of the query grid, put the name
of the field that you want to copy *from*:

[A].[fieldname]

Run the query with the ! icon.
 
Back
Top