Have a yes/no checkbox - 3000 records. I want to change that field's data [Locked-in1] to text field [Locked-in2] and then delete the original yes/no box (I'm running out of fields).
Think I would use a query to convert the yes/no data, [Locked-in1] to a text field [Locked-in2] but not sure how i would delete [Locked-in1]?
eventually want to replace the check box on a from with a drop down list of choices...but show past records in text
Thanks for your help.
John