Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Survey Form (Access 2000)

    I have a survey form that I would like to send out to the public and they send it back to me. I want to be able to put their answers in an access form and be able to have a report that gives me a count of how many chose those different answers in a certain month. (I will attach a copy of the survey in paint, if that would help, just ask). For example how many people chose Carpenter Park Rec Center, How many chose Oak Point Center, etc. All the way down for every check box from the survey. I am pretty clueless I would appreciate any suggestions. I think there must be some sort of count expression for the report or maybe I have to do it off of a query first?? Would this be done better through Visual Basic, using Access as a Data Source? All suggestions welcome!!!!
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    In my survey applications, I have three tables. Survey (with survey header/mailing information), Question (with each question) and Response (an intersection table between Survey and Question). When I do statistical reporting on the returned responses, I can do domain aggregate functions in the report on the responses for each Question ID in the Response table.

    I know that domain aggregate functions are not efficient, but I haven't had any issues with this method. Someone else might know a better way.
    HTH

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access Survey Form (Access 2000)

    You can do COUNT and SUM expressions on either a report or a form, but you might want to just use a query the does Group By functions as well as counts and sums. Turn on the Totals in the View menu for a query to see what your options are. You can then base a form or a report on the query. CrossTab queries are also useful if your data is very structured, but they generally don't work with forms and reports. Of course you could do all this in code, but my philosophy is to avoid code if there are tools that will do what I want. Hope this is useful.
    Wendell

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Thomas,
    Thank you for all the help. Between you and Wendall It worked out very well. Always thankful for the help given here.
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Wendall,

    The help you gave, greatly appreciated. It worked out well.

    Always so greatful
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Thomas: I would love to see your survey Db. If you would, could you attach it to an e-mail. My address is bckessinger@cmhmetro.net. TIA.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Client confidentiality prohibits me from doing that. The application is very survey/client specific, so removing the confidential portions would leave very little to look at. However, I would be happy to answer any questions or provide non-client specific information. Let me know what would be helpful to you.

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Thomas: Could just the structures be viewed?

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    I attached the backend of the db, so that you could see the structure. It is a simple setup, just three tables, as described in my first response. If the survey has comments that the respondents write in as text, I add a fourth table for the comments since all the standard survey responses are numeric.

    I know this is sparse (no data), but I had to pull out all the confidential data, which turns out to be everything. A variation on this has worked for all the survey applications I have written, even though they have addresssed various types of companies.
    HTH
    Attached Files Attached Files

  10. #10
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Survey Form (Access 2000)

    Thomas: Thanks. This will give me a start. Appreciate the reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •