R
Relative Begginer
Hello. I imported an Excel sheet into Access creating a new table. We have
a text column that I would like to make into a check box column. The data is
essentially y/n already. I need to know what replace the "x" we have now (for
"yes") with so when I go to design view and change the field Access doesn't
erase the data just makes it a "yes" if there's an "x" in the field or "no"
if the field is blank.
Would I replace "X" with 1/0, y/n or something else? Would I need to not
have blank record entries? In the example below, use a 1/0 approach instead
of using "X".
Example:
Header is "School"
Record 1 is "X"
Record 2 is " " (Blank)
Thank you for any help you can give me!
a text column that I would like to make into a check box column. The data is
essentially y/n already. I need to know what replace the "x" we have now (for
"yes") with so when I go to design view and change the field Access doesn't
erase the data just makes it a "yes" if there's an "x" in the field or "no"
if the field is blank.
Would I replace "X" with 1/0, y/n or something else? Would I need to not
have blank record entries? In the example below, use a 1/0 approach instead
of using "X".
Example:
Header is "School"
Record 1 is "X"
Record 2 is " " (Blank)
Thank you for any help you can give me!