D
dyaussi
I would like to add about a dozen fields to my table and don't really know
quite how to go about it. What I would like is the first field to be a Y/N
data type and have a field associated with that so if the answer is Y it
puts in a value - say 4. If the answer is N it puts in a value of 0. Then
I'll have a field called Total Points and it will be the value of all the
fields added together. Does anyone have a clue as to how to accomplish this?
I tend to think in "pictures" so I can see how I want it to be in a form but
don't know how to design it.
quite how to go about it. What I would like is the first field to be a Y/N
data type and have a field associated with that so if the answer is Y it
puts in a value - say 4. If the answer is N it puts in a value of 0. Then
I'll have a field called Total Points and it will be the value of all the
fields added together. Does anyone have a clue as to how to accomplish this?
I tend to think in "pictures" so I can see how I want it to be in a form but
don't know how to design it.