Update Query

[David M C]

I have two tables:

ScheduleOfRates:

SORCode (pk)
Description
Unit
Rate
SMV (currently empty)

NewRates:

SORCode (pk)
Description
Unit
Rate
SMV

I would like to update the SMV field in ScheduleOfRates using the SMV field
in NewRates where the SORCode matches. How can I do this?

Thanks,

Dave

 

[John Spencer]

First, backup your data. You cannot undo this other than by restoring from
a backup.

In the query grid:
--Add both tables to a query
--Join the tables by dragging SORCode to SORCode
--Add the field ScheduleOfRates.SMV to the list of fields
--Select Query: Update from the menu
--In the update to row, enter
[NewRates].[SMV]
--Select Query: Run from the menu

SQL statement would look like
UPDATE ScheduleOfRates INNER JOIN NewRates
ON ScheduleOfRates.SORCode = NewRates.SORCode
SET ScheduleOfRates.SMV = NewRates.SMV

 

[David M C]

Thanks. Worked Perfectly.

First, backup your data. You cannot undo this other than by restoring from
a backup.

In the query grid:
--Add both tables to a query
--Join the tables by dragging SORCode to SORCode
--Add the field ScheduleOfRates.SMV to the list of fields
--Select Query: Update from the menu
--In the update to row, enter
[NewRates].[SMV]
--Select Query: Run from the menu

SQL statement would look like
UPDATE ScheduleOfRates INNER JOIN NewRates
ON ScheduleOfRates.SORCode = NewRates.SORCode
SET ScheduleOfRates.SMV = NewRates.SMV

I have two tables:

ScheduleOfRates:

SORCode (pk)
Description
Unit
Rate
SMV (currently empty)

NewRates:

SORCode (pk)
Description
Unit
Rate
SMV

I would like to update the SMV field in ScheduleOfRates using the SMV
field
in NewRates where the SORCode matches. How can I do this?

Thanks,

Dave