Problem using updated fields in update expressions

N

Nik

Probably being very dense but...

If I update a database table field in an "update" action
query, how do I then use the updated value of this field
in another "update to" expression in the same query?

At the moment I'm only getting the "before update" value
of the first field being used in the update expression of
the second one.
 
S

SteveS

Nik said:
Probably being very dense but...

If I update a database table field in an "update" action
query, how do I then use the updated value of this field
in another "update to" expression in the same query?

At the moment I'm only getting the "before update" value
of the first field being used in the update expression of
the second one.
Click to expand...

You could try creating a variable and use the variable in both Update
queries....
 
Top