converting info to a Pick box's

J

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
 
T

Terri Pecora

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

Thanks
Terri
 
Top