Joining Fields?

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

 

[Rick Brandt]

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.

What your describing (other than the Yes/No fields) belongs in a query, not
in your table. You should never store data that can be easily derived from
other data.