Problem using updated fields in update expressions

  • Thread starter Thread starter Nik
  • Start date Start date
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.
 
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....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update primary key field with multiple "where" clauses 0
Update Query Help *urgent* 0
DSum update query with multiple fields 0
Use Update Query to Add Fields 1
update two fields at once 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
extract 3 numbers from a string 0
Update Value in Table based on to that of Another Field 1

Back
Top