Validation question

  • Thread starter Thread starter Reggie
  • Start date Start date
R

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.
 
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.
 
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




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

In query design view:

MyExpressionName: Abs([MyYesNoField])*10
 
Back
Top