converting info to a Pick box's

[Jason Frazer]

I have a table with "X" in columns or blank.
I want to convert the x values into a checked pickbox and
the blank values into an unchecked pickbox.
What would be the best and easiest way to acomplish this.

Thanks for you help
Jason

 

[Terri Pecora]

Run an update query to change all the "X" to "Yes"
Then change the datatype to Yes/No.

Thanks
Terri