Recent content by Dartos

I managed to get copy and paste to work had to click the top cell when it was a + cursor not the text one. So that makes half of the first question much less of a problem. I can't just copy and paste the respondent ID though since it is in the format 1,1,1,2,2,2 not 1,2,3,1,2,3 so copy/paste...

Thanks Richard. I'd seen that in my searching and its the outcome I'm looking for (though much more detailed and complex than I need) but I can't figure out how to make mine like that or to change that to be mine. Is what I'm looking to do really complex? Should I just tell my supervisor that...

Wow... damn... you mean the easiest way for me to do it is with all that code and stuff about sql and vb? None of that made sense to me... Not even just the code blocks, I lost track of the conversation bits too! :S If I was going to be doing this a lot it would be fine to spend ages learning...

So I did some reading and put in a different design. It looks messy as anything but it seems like it should work and I can try use queries and crosstabs to produce a table that is readable for my analysis. The design is below and I've got 2 (more specific) questions now. tblQuestions (PK)...

Thanks for the reply. I figured it would have been asked before but I couldn't find it in my searches. I was over thinking the search terms a bit. Will go have fun reading some more.

Hi guys, So I'm doing research and have been asked to use access instead of other programs for my current project. I'm doing a survey and collecting responses. I have the master table which is where I enter the responses. However, each question has been written to match several classification...