Data Type

[JM]

What data type can I use for a Yes/No/DK? Would that be
text? (I think Y?N would not work.)

The coding ends up as
yes=1
no=2 and
DK= 0

 

[JM]

Ok. So instead of formatting data type as "text", you
suggest "number".

The form I am using codes the options within the option
group as 1, 2, 3.

I am wanting 1, 2, 0 - but the data corresponds to a "yes"
answer, a "no" answer, and a "don't know" answer.

 

[Rick Brandt]

Ok. So instead of formatting data type as "text", you
suggest "number".

The form I am using codes the options within the option
group as 1, 2, 3.

I am wanting 1, 2, 0 - but the data corresponds to a "yes"
answer, a "no" answer, and a "don't know" answer.

If you want to set the value using an option group you should be able to assign
whatever numeric value you want to each option. When option button or toggles are
added to the option group Access will default to assigning the values 1, 2, 3, etc.,
but you can manually change these to whatever numeric values you like.

 

[Marin]

Hello

Read the online help of Microsoft Access... topic option
group!

So there is the problem-solver:

Of course you have to use number. Convert that field to
number, field size - byte (save disk space).

Then on the form create an option group by using the
Control Wizard. Label your options Yes, No and DK, make a
default choice (or don't), then change the values as you
have mentioned (1,2,0). Store the values in your field,
choose your type of controls, name your option group and
you're ready!