I need help w an Update Query

[Dave]

I have two Tables, both tables have the same 3 Fields EmplID, LName, FName.

Table One only has values for the EMPLID and is missing the LName & FName
values. Table Two has all of the information needed.

I need to Update the LName & FName in Table One from the LName & FName in
Table Two..

I have tried various methods and cannot get the results I am looking for.
This is my first Update using 2 tables.

Dave

 

[Jeff Boyce]

Dave

Open a new query. Select both tables. Add the (empty table's) LName and
FName fields to the grid.

Join the two tables on EMPLID. From the menu, select query and Update
query. A new row appears in the grid.

Since both tables have the same names for the fields, you'll have to tell
Access which table's fields to use to update with. Use something like (your
syntax may vary):

[YourSecondTable]![LName]

to tell Access to use the table that has the value in the field. Substitute
your actual table's name.

 

[Dave]

I am still stuck.

Is the Field - Table in the Query the one getting the information or the one
sending the information?

Thanks

Dave

Open a new query. Select both tables. Add the (empty table's) LName and
FName fields to the grid.

Join the two tables on EMPLID. From the menu, select query and Update
query. A new row appears in the grid.

Since both tables have the same names for the fields, you'll have to tell
Access which table's fields to use to update with. Use something like
(your
syntax may vary):

[YourSecondTable]![LName]

to tell Access to use the table that has the value in the field.
Substitute
your actual table's name.

--
Good luck

Jeff Boyce
<Access MVP>

I have two Tables, both tables have the same 3 Fields EmplID, LName, FName.

Table One only has values for the EMPLID and is missing the LName & FName
values. Table Two has all of the information needed.

I need to Update the LName & FName in Table One from the LName & FName in
Table Two..

I have tried various methods and cannot get the results I am looking for.
This is my first Update using 2 tables.

Dave

 

[Jeff Boyce]

Dave

You may want to spend a little time in Access HELP looking at update query.

Both values will end up in the grid. The "empty" one you put in the top,
the "full" one (that you're using to update the other) goes further down in
the grid, in the row titled "Update to".


--
Good luck

Jeff Boyce
<Access MVP>

I am still stuck.

Is the Field - Table in the Query the one getting the information or the one
sending the information?

Thanks

Dave

Open a new query. Select both tables. Add the (empty table's) LName and
FName fields to the grid.

Join the two tables on EMPLID. From the menu, select query and Update
query. A new row appears in the grid.

Since both tables have the same names for the fields, you'll have to tell
Access which table's fields to use to update with. Use something like
(your
syntax may vary):

[YourSecondTable]![LName]

to tell Access to use the table that has the value in the field.
Substitute
your actual table's name.

--
Good luck

Jeff Boyce
<Access MVP>

I have two Tables, both tables have the same 3 Fields EmplID, LName, FName.

Table One only has values for the EMPLID and is missing the LName & FName
values. Table Two has all of the information needed.

I need to Update the LName & FName in Table One from the LName & FName in
Table Two..

I have tried various methods and cannot get the results I am looking for.
This is my first Update using 2 tables.

Dave