KARL DEWEY said:Yes/No is stored in Access as -1 & 0 -- that is minus one & zero.
If you want Yes the it is easy. Use Int([YourYes-NoField]) to give a
positive one value. With that you can sum them and then multiply for point
value.
Rennie said:I'd like to assign a point value to yes/no answers (field) in Access. The
goal would be to tally up a score based on the point value of each yes
answer. Can this be done? Where is it done? A query? Report? I'm lost!
Rennie said:Can I assign a number other than 1? What I have is a list of items that must
be completed on a submittal. Each item is weighted as either 2, 4 or 7
points, so the value of 'yes' will be depended on the question being asked.
KARL DEWEY said:Yes/No is stored in Access as -1 & 0 -- that is minus one & zero.
If you want Yes the it is easy. Use Int([YourYes-NoField]) to give a
positive one value. With that you can sum them and then multiply for point
value.
Rennie said:I'd like to assign a point value to yes/no answers (field) in Access. The
goal would be to tally up a score based on the point value of each yes
answer. Can this be done? Where is it done? A query? Report? I'm lost!
KARL DEWEY said:Yon can not 'assign a number other than 1' but you can calculate a value.
How will it know what question/value? Do you have a value field in the
question table? If so then use this calculation --
Point Value: [QuestionValue]* Int([YourYes-NoField])
Rennie said:Can I assign a number other than 1? What I have is a list of items that must
be completed on a submittal. Each item is weighted as either 2, 4 or 7
points, so the value of 'yes' will be depended on the question being asked.
KARL DEWEY said:Yes/No is stored in Access as -1 & 0 -- that is minus one & zero.
If you want Yes the it is easy. Use Int([YourYes-NoField]) to give a
positive one value. With that you can sum them and then multiply for point
value.
:
I'd like to assign a point value to yes/no answers (field) in Access. The
goal would be to tally up a score based on the point value of each yes
answer. Can this be done? Where is it done? A query? Report? I'm lost!
Rennie said:Karl, you've been very helpful and I think what you are describing will work
for me - just one little problem - I'm lost as to where this information
you've given me resides in Access. Is this expression in the table, query, or
report? If in one of these places, where specifically? Sorry to be a dunce, I
don't get to work in Access often enough to be super comfortable with it.
Thanks again.
KARL DEWEY said:Yon can not 'assign a number other than 1' but you can calculate a value.
How will it know what question/value? Do you have a value field in the
question table? If so then use this calculation --
Point Value: [QuestionValue]* Int([YourYes-NoField])
Rennie said:Can I assign a number other than 1? What I have is a list of items that must
be completed on a submittal. Each item is weighted as either 2, 4 or 7
points, so the value of 'yes' will be depended on the question being asked.
:
Yes/No is stored in Access as -1 & 0 -- that is minus one & zero.
If you want Yes the it is easy. Use Int([YourYes-NoField]) to give a
positive one value. With that you can sum them and then multiply for point
value.
:
I'd like to assign a point value to yes/no answers (field) in Access. The
goal would be to tally up a score based on the point value of each yes
answer. Can this be done? Where is it done? A query? Report? I'm lost!