R
RebeccaMinAR
Again I turn to my mentors in the shiny computer screen for some help with a
thorny issue.
As some of you may recall, there is this silly survey that I'm responsible
for creating. I've got it up and running wonderfully, and it's storing my
value in a field in my project level table like a dream. However, my next
challenge is to take that numeric value, change it into a word (Level 1 is
0-10, Level 2 is 11-25, etc.) and put that in another field so that we can
display it in another form.
My challenge is twofold. One, I need to find a way to make the numeric field
automatically calculate a level and add it to the appropriate field in the
table. Secondly, I need to find a way to make my project level form refresh
once we close the survey form and return to it (the survey is accessed by a
command button on the project form). Any assistance would be greatly
appreciated - this is my last big task before I leave for my honeymoon, so
the sooner it's done, the sooner I'm out of here!
thorny issue.
As some of you may recall, there is this silly survey that I'm responsible
for creating. I've got it up and running wonderfully, and it's storing my
value in a field in my project level table like a dream. However, my next
challenge is to take that numeric value, change it into a word (Level 1 is
0-10, Level 2 is 11-25, etc.) and put that in another field so that we can
display it in another form.
My challenge is twofold. One, I need to find a way to make the numeric field
automatically calculate a level and add it to the appropriate field in the
table. Secondly, I need to find a way to make my project level form refresh
once we close the survey form and return to it (the survey is accessed by a
command button on the project form). Any assistance would be greatly
appreciated - this is my last big task before I leave for my honeymoon, so
the sooner it's done, the sooner I'm out of here!