How can I write form field data into rows rather than columns?

Hi All,

I am trying to create a simple online questionnaire, using frontpage 2003, to go on our intranet. The idea is to use it for entering workshop evaluation data (happy sheets filled in by our client delegates at the end of an event) and automate the process of reporting on this data.

So for instance, Question 1 might read: 'To what extent were the workshop objectvives met?', below this there is a dropdown box (1-5) rating and a txt box for entering any comments. Question 2 might say:  'What benefits have you personally derived?' and just have a txt box to enter the delegates comments, and so on and so on.

My form is setup and connected to my access db but I only appear to have the option of writing form fields into columns. What I want is for each question (rating and comment response) to go into a seperate row in the db. I suspect that I need to insert some kind of looping code for this to happen but its a bit beyond me at the moment - any pointers or sample code gratefully received as I'm completely stumped!

Many thanks in advance,

Lenny


Mad_LennyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hhammashCommented:
Hi Lenny,

You do not have to worry about how the data are entered in the database,  you can do what you want in the report.

Question 1 has a drop down and a text box,  so in the table desing make:

Field Name
Question1cbo
Question1txt
Question2txt
Question3cbo
Question3txt
Question3rdo

cbo=combo box
txt= text field
rdo=radio button
....etc

Then on the report page you can position the info as you like

hhammash
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hhammashCommented:
I did a huge questionnaire before in the same way,  and since I am the webmaster and have access to the database, I created the reports in MS Access.

You can also create a web page for the report.

In the questionnaire you will be gathering count on the questions also right?  like how many said yes or no to something ..etc
0
Mad_LennyAuthor Commented:
Hi Hammash, sry for not replying sooner (plate spinning other projects), but hope to spend time on this over the weekend and work through your replies, many thanks...and yes I will want to be gathering count on the questions. The reporting side of things should be fun, but I'll worry about that (and no doubt post a new question!) once I'm happy that the data is going in ok...

Will, let you know how I get on,

Lenny
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.