Eliminating last 3 characters of data from each value of an entire column of values

[June7]

Where does CAMS_ID come from? Is this a foreign key related to an autonumber primary key in another table?



Identifier data should normally be in text field - SSN, zip code, phone number, employeeID, etc., even if only digits are involved. These values are usually a fixed length and can have leading zeros that would be dropped in a number type field. This is not numeric data in the sense of currency and quantity that will be used in mathematical operations to sum and average.

[lfpm062010]

Can you verify the data type of CAMS_ID in the table? To do that, right click on the TABLE and select "Design View" and see what data type is for column "CAMS_ID".

If it is number, then see what is under "Field Size" and "Format" below. The format should display nothing or "General Number". Then it will display the number unless it actually have a decimal number.