Want to change yes/no field to text field but keep data

[jmuirman1]

I have 2500 or so "yes/no" records in the field, [payment req sent?] but need more info than yes or no. so i want to change the existing field or create a new field.



I also want to eliminate the original field if i need to create a new field.

Thinking some kind of a query will do this...

thanks for your help.

John

[moke123]

What do you mean by "More Info"?
Can you use an IIF() in the field?

IIF(MyField = 0,"SomeInfo","SomeOtherInfo")

[Gicu]

Add your new field to the table than create an update table to convert the existing data to text using an expression in the Update field:
IIF( [payment req sent?] =True,"YES","NO").

Once you run it you can open the table in design view and remove the old field. You will need to review all your other objects (queries, forms, etc.) to make sure they now reference the new field.

Cheers,

[jmuirman1]

by more info i mean more descriptive text than yes/no...like "awaiting confirmation before sending"...

[Bob Fitz]

by more info i mean more descriptive text than yes/no...like "awaiting confirmation before sending"...

Then replace the "Yes" and "No" in the expression that Vlad gave you with "awaiting confirmation before sending" or whatever text you require

[Gicu]

@Bob, I think the OP wants to preserve the existing data (Yes/No) and for the future to be able to add different statuses/comments. I usually have a different approach in that I use a couple of fields, one called PaymentStatus (where the "more info" goes) and PaymentDate which also acts as a confirmation field similar to [payment req sent?] - if PaymentDate is populated then the [payment req sent?] =True, if the date field is empty then [payment req sent?] =False.

Cheers,