Attn John Vinson.

  • Thread starter Thread starter martym
  • Start date Start date
M

martym

Sorry wasn't sure how to respond to you without email.

Each one of the questions is a field (sorry for the bad
database design...I am new to Access). I basically have
to come up with a score for each patient. I have to count
up how many times the individual client scored 1's and
count how many times they scored 2's out of the 20
questions. Then I have to add the counts together to get
their score. What is ironic is this is a test for serious
mental illness, which I am going to need to administer to
myself after thinking I could create such a form! =)

Thanks for your help.

Marty

Subject: Re: Calculations on Forms--Is this possible?
From: "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com>
Sent: 11/25/2003 4:02:02 PM




I have a form where a user enters in a score of 0-4 for 20
questions. I then need to count how many answered scored
1 over the 20 questions and then another that scored 2
over the etire 20 questions. How do I get it so that it
automatically calculates on the form? Is this even
possible?
Click to expand...

It's possible, but we'll need a bit more information to
say how. Are
these 20 questions 20 *fields* in a table, or (much better
design) 20
*records*? You say "how many answered scored 1" - how many
of the 20
questions, or how many people entered a score of 1, or
what?


..
 
martym,

Newsgroups are not just a substitute for e-mail so you can get private
consulting; they are a teaching and learning forum, so all can benefit from
the questions and answers. Just as John posted a Reply to your original
post, you should follow up by posting a Reply to his Reply -- this keeps the
messages together ("in a thread") so that someone can come along later and
see the exchange. Posting a separate message with the person's name in the
subject doesn't provide that kind of message-linking and reduces the
effectiveness of the newsgroups.

For other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
 
I apologize if I offended you by not responding properly.
I in fact did hit a post reply to his original posting as
you have so kindly instructed me below but I did not see
my message after it said it was posted. So I did it this
way as a last resort. I am a new to this and appreciate
any help I can get. Obviously I need even more help than
I thought ;)
 
Back
Top