Sorting a questionnaire by gender

[uchiha37]

I have a questionnaire which I need to separate into male and female. I have to look at what answers males gave and what answers females gave. How would I go about doing this? The data was originally in Excel, but I imported that. The data I have at the moment includes:

Survey Impression (Every person who completed the survey has a unique impression ID, so one user 16 impression ID, as one impression is equal to one question on the questionnaire)

Completed to step (How far they have completed the survey until, goes up to 16)

Question number

Answered choice number (This would be the choice on the questionnaire that they answered)

Answered choice (The actual text of that answer)


I would be really grateful if someone could give me some tips or a heads up on where I should begin, I have been doing it for a few hours now and haven't really got anywhere. Thanks.

 

[Trevor G]

I have a questionnaire which I need to separate into male and female. I have to look at what answers males gave and what answers females gave. How would I go about doing this? The data was originally in Excel, but I imported that. The data I have at the moment includes:

Survey Impression (Every person who completed the survey has a unique impression ID, so one user 16 impression ID, as one impression is equal to one question on the questionnaire)

Completed to step (How far they have completed the survey until, goes up to 16)

Question number

Answered choice number (This would be the choice on the questionnaire that they answered)

Answered choice (The actual text of that answer)


I would be really grateful if someone could give me some tips or a heads up on where I should begin, I have been doing it for a few hours now and haven't really got anywhere. Thanks.

Welcome to the forum

In the table can you add a Gender field with 2 options as drop down, male female

 

[uchiha37]

How would I add a male and female string to the table?

 

[Trevor G]

How would I add a male and female string to the table?

You need to change the view of the table to design view then where it shows your field names go to the last one and below it type in a new name like "Gender" press the tab key and you will move into the datatype, click the list and select Lookup Wizard, then step through the wizard you will type the value, then make sure it is just one column and then as you move further on you can add in the text Male then the line below Female or the other way round continue the wizard until you finish.

If you can't see the table press F11 on the keyboard this will display the database window (navigation pane) and you will see the tables on the left side near the top.

 

[Brianwarnock]

If the gender isn't already being carried in the table how do you know who is what? If you already know you don't need another field.

Brian