Carolyn, Use the Table > Update Column function with the expression:
Table to Update: Distance_Table_Name Column to Update : Distance_metres_column_name Get Value From Table : Distance_Table_Name Value: Distance_metres_column_name / 1000 Regards, Bill ========================================================================= ----- Original Message ----- From: "Carolyn Bergin" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED] directionsmag. com" <[email protected]> Sent: Friday, June 10, 2005 12:03 PM Subject: MI-L Simple update column > I've been away for year and cant remember the simplest things. > > > > I want to update a column that contains distances in m and I want them to > read in km. Basically I need to delete from the column the ,000 that > follows each number. (ie change 10,000 to read 10) > > > > Can anyone help? > > > > Thanks Carolyn > > > > > > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16771
