Change field values

[bowldog]

I need to change the value of a field from a number(1) to a letter (X). Can this be done? Help is always appreciated in advance.

 

[antomack]

Assuming the field is set as text and not number then you just need to run a query to update all values for the field to 'X' where the value is '1'.

If the field is set as a number then you'll have to change the data type to text and then do the update query.