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

Posted on 2006-03-23
Last Modified: 2013-12-24
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,


Question by:Mad_Lenny
    LVL 14

    Accepted Solution

    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

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

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

    LVL 14

    Expert Comment

    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

    Author Comment

    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,


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
    Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
    The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
    The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now