Hello, I have a table that had values that were NUMERIC (eg. 2506.00) and have now been converted to TEXT properties. Now I need to remove the decimal and the 2 trailing zeros. The field name is Group_Index. The table is called Parcel_Info. Also, in case you need to know, the values are not all 4 digits. They actually start at 1.00, then go all the way to 2506.00. So I want 2506.00 to be changed to 2506. Would I do this using an update query? How should it be written? If you can provide me with the SQL that would be even better! Using Access 97, FWIW. Thanks!