how to change to Boolean data type??

[Beblessed]

my teacher asked me to do Access homework to change data type from Text to Boolean. Data in "Owned car" field show as Y or N

so I click on Design View and change datatype of this field from "Text" to "Yes/No" , than when I saved it show a message

When I back to Datasheet view, all data in "Owned car" field change to be "No".

How can I change data type to be Boolean type without deleting my original data??? I want them to show the same as Y or N.

 

[Oldsoftboss]

Create a new field in your table.
Run an update query to append the data in the new field.
Delete the text field.
Rename the new field to the name of the old field

Homework done.