Question: Table - Assigning Numerical Values (and then some)

  • Thread starter Raymond Gonzales
  • Start date
R

Raymond Gonzales

I was just given a database to work on here at work, and
they told me to play around with it and configure it to my
liking before commencing the joyful two-week process of
data entry. I've almost got it set up how I want it, but I
have one (or two) small improvements left to make that I
can't seem to figure out simply through playing around.

First off, a brief explaination of what I'm entering:
survey responses. Various services were listed, each with
two questions: "How quickly was it performed" and "how
completely was it performed." Choice of answers for every
question is the same, with the options
being "Excellent", "Very Good", "Good", Fair", "Poor",
and "N/A".

Here's what I have figured out so far:

Display Control: Combo Box
Row Source Type: Value List
Row Source: Excellent;Very Good;Good;Fair;Poor;N/A

Here's what I still want to do:

I want to assign numerical values to the answers. Entering
a "1" into a field will come up as "Excellent", a "2" will
come up as "Very Good", all the way up to a "6" counting
as "N/A". On top of this, I would like any entry of "6" to
make the following field come up as "N/A" also, but I want
this to be the case with answers of 6 (N/A) ONLY! (If "how
quickly was it performed" is "N/A", I want "how completely
was it performed" to also be "N/A".)

So... how do I do this?
 
Top