Records and columns with repeating fields

A

Ana

Hi,

I created a table that includes information we gathered from a training we
offered to some clients. They completed a pre and post questionnaire. Our
questionnaires had multiple choice questions. I created a database with the
client as the primary key and entered their answers from the questinnaire in
the database in separate columns for the pre and post questionnaires. My
problem is that now I do not know how to analyze the data per multiple choice
question. Meaning, if the choices of a question were: 1, 2, 3 or 4, I cannot
find a way to pull out those that answered 1 before and after the training at
the same time. When I do a chart graph, it gives me the same number of
people that answered 1 in the pre and post questionnaire. I tried limiting
the criteria and it does not work either. Does anyone know what I did wrong
in the database? Perhaps I needed to arrange it in a different way.

Thank you for your time.

Ana.
 
K

KARL DEWEY

Does anyone know what I did wrong in the database?
You made a spreadsheet.
Is your table like this ---
Client Pre-1 Pre-2 Pre-3 ... Post-1 Post-2 Post-3 ...

What do you want the data to look like feeding the chart graph?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top