Quote Originally Posted by CeeBee View Post
Easiest I can think of:

****Backup db****
Update the table, add new column [tmp] of type numeric double, default value NULL (you will be using this as a "failed to update" indicator)
Run query to update
UPDATE Table1 SET Table1.tmp = [your_money_field];
Validate all data was updated
SELECT * FROM Table1 WHERE tmp IS NULL
Drop old column, rename tmp to that name
Ok, the table is called Distribution Shipment Detail. Old Field is Gross Weight, new field is TMP.

Is it
Field: Gross Weight
Table: Distribution Shipment Detail

UPDATE: Distribution Shipment Detail SET Distribution Shipment Detail.TMP = [Gross Weight]