update a field 1

[bosk0]

I need to update a field in a table named ClientContacts. The field needing updating is named CARef#. There is a second filed in named CCRef#. I have a table with contains only 2 fields they are CARef# and CCRef# named PopCARefField.

An example of the date in the PopCARefFiled table is

CARef# CCRef#
23261 1
23703 2
34174 3 etc.......

I know it is an update quesry, but am having a senior moment and cannot wrap my head around it.

The desired outcome is to update ClientContacts.CARef# field with the number in the PopCARefField.CARef# where the CCRef#'s in both tables match.

Any assistance is appreciated.

 

[dhookom]

Create a select query with the two tables. Then convert to an update query to expose the Update To row. Enter the field with the source value under the target field.

This assumes the join involves a primary key.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[bosk0]

Duane, Thank you. That did it. Have a star