Process List of Questions and Store Results in Single Row

[Gord W]

I am trying to design a new Access 2007 database that needs to process a list
of questions and store the results in a single row. The number of questions
is likely to change over time, but all questions must be answered with a
value between 0 and 10. I am not experienced with VBA, but I suspect I will
need to use some sort of "Do While" or "Do Until" loop to work through the
questions.

 

[Jeff Boyce]

From your description of "how" you intend to solve this, I'm going to guess
you have experience using Excel spreadsheets.

That's too bad, because you won't get much use of Access'
relationally-oriented features/functions if you insist on feeding it 'sheet
data! You may have to unlearn a lot before Access can actually help.

Is there a reason you aren't using Excel for this?

Note: if you are looking for a way to handle a
survey/questionnaire/response scenario using MS Access (a relational
database!), Duane H. has a very good example:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Gord W]

Thank you. Your suggestion to look at Duane Hookum's sample survey database
was quite helpful.