Update with Computed Field

[garygdj]

Is there a workaround to update a table with a computed field.

 

[garygdj]

I don't really have a choice. The data I'm dealing with is from a client and we need to manipulate the data so that we will have all the information we need in order to make the data work on MSP. The client is not on MSP so we must do this in order to make MSP work.
I tried using the temp table but when I run the update query it says that it runs but when I look at the table the fields are blank.

 

[The_Doc_Man]

Pat's advice is right. Revisit your query. Play with the fields one at a time to see if one of them is causing your operation to fail.

Reasons why something might fail to update the temp table and yet give no error messages:

Over-stringent WHERE clause
Improperly-formed JOIN that results in nothing selected
Source fields include nulls and your update query doesn't correctly handle the nulls with an IsNull function.

 

[garygdj]

Msp

Mortgage Servicing Package

Fidelity MSP is the servicing system that the over 50% of the mortgage companies in the US use to service mortgages.