What is the data type of the column being updated? It sounds like a decimal definition without enough places specified. One would think the original entries would be subject to the same problem. However, I created this problem. I defined a field as Decimal and specified 5,2. It would accept the number 98, but updated it to 9.99 when I applied the update as Col_Name*-1. I could go back and input 98 in the field and it would accept the data. I am not sure why this worked as it did, it confounds my understanding of how the decimal data type works. I would suggest you check the data type and respecify as float and try your update. Backup all tables up, cya etc etc
William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Terry McDonnell [mailto:[EMAIL PROTECTED] Sent: July 13, 2004 09:56 To: [EMAIL PROTECTED] Subject: RE: MI-L Update column problems How about 0 - ColumnName? e.g. If col = 98, then result will be -98 Terry McDonnell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:01 To: [EMAIL PROTECTED] Subject: MI-L Update column problems Here's the problem in short. I am trying to use Update Column to take a column and make all the numbers in the column negatives. When I take the column and multiply it by -1, I get -9.9999999 instead of the desired value. What am I doing wrong this time because I have been able to do this before? Sincerely, Brian Van Druten Forestry Technician Alligator River NWR Manteo, NC --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12581 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12584 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12596
