Using At Your Survey with existing data

  • Thread starter Thread starter Barn Yard
  • Start date Start date
B

Barn Yard

Good Day,

I am somewhat new to relational databases and I apologize ahead of
time for anything I say that doesn't make sense. I am using Duane's
ATS database to build my survey relational database from an existing
non-relational table. First, I started with the original table(one
record per user with questions as the fields in the one table). Using
append queries I have been able to get tblResponses like DN's in AYS.
However the responses do not have labels just numbers. For example,
when I report I would like to have the labels ('Somewhat Likely'
instead of the number '4' and 'NA' instead of '11', etc..). I'm
unsure on how to accomplish this. Any help would be appreciated.

Thanks in advance,
--Brandon
 
The quickest method is to do a search and replace on the data table
Find: 4
Replace with: 4-Somewhat Likely
Another method would involve creating a lookup table with a field of the
same data type as the Response and another field with the "label". You would
need to include this lookup table in your queries.
 
I am thinking of going with the latter suggestion. Since many of the
questions share the same responses, will this allow me to not having
to enter repsonses for each question with the same type of responses?

To illustrate: For a particular survey (1 of 5), there are 4 different
reponse types:

1. Rate 1 through 10 w/ NA *there are 28 questions like this*
2. Memo box *4 open-ended answers*
3. Mark All That Apply *9 (Yes/No)*
4. Unique multiple choice *9 including 3 having choice "d. please
specify: ___________" *


So, would I have (1+1+1+9 = 12) records in my tblAnswers pertaining to
this particular survey? And, would the field names be the various
choices for each repsonse type? As you probably already know, my goal
is to generate reports very similar to AYS with the multiple reponses
labels replacing the numbers in the frequency tables. I hope I'm on
the right path.

Thanks so much,
-B
 
This would be a bit of work (that's why I didn't include it in the demo).
You would need to create two tables:
tblRespLists
=================
ListID autonumber primary key
ListTitle

tblRespListDetails
=================
ListDetID autonumber primarykey
ListID link to tblRespLists.ListID
ListDetTitle
ListDetSort (single numeric for sorting)

tblQuestions would need a field added
==================
ListID link to tblRespLists.ListID

tblResponses would need a field added (or modified)
====================
ListDetID link to tblRespListDetails.ListDetID

You would need code in the on current event of sfrmResponses to update the
row source of the combo box to the values from tblRespListDetails.
 
Back
Top