I am using access 2003. I am really new to access and databases in general. I have a value in a field that i need to convert to text. Such as the value is 1 and the text that correlates is meets, the value is 2 and the text is does not meet. I dont care if I have to convert the value at the table, query, or report level...any of them will do.
This is probably a very simple question and answer but I cant figure it out or find the answer.
You question is a little confusing. Is the data in the field you want to convert formatted as a text field? I would assume no. You can create a field in the same table that will receive the converted data, format it as a text field, then create an update query to transfer the data over to the new field. When your done you should be able to switch the field names. If you just change the format from whatever it is now to text you may loose data.