Validation question

[Reggie]

I'm using fields in my table that require a Yes/No answer.
Does anyone know if there is a way to assign a
mathematical value to this type of field if the user
selects Yes. For example the user selects Yes and that Yes
answer is worth 10 Points. Any help would be greatly
appreciated.

Thanks
Reggie.

 

[Roger Carlson]

Well, in Yes/No fields (in Access), Yes = -1 and No = 0 (that's what is
actually stored) Therefore the formula Abs(MyYesNoField) *10 will return 10
for a yes answer.

 

[Guest]

Thanks Roger, I'll try that

Reggie

-----Original Message-----
Well, in Yes/No fields (in Access), Yes = -1 and No = 0 (that's what is
actually stored) Therefore the formula Abs(MyYesNoField) *10 will return 10
for a yes answer.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.

 

[Tom Bock]

Great idea... I had to make a slight modification though to get it to work.

In query design view:

MyExpressionName: Abs([MyYesNoField])*10