Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts
    We have surveys that we would like to enter in a database and have the report form count the number of "1's", "2's", and so on for a specific period of time.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='lockwoodbf' post='776298' date='21-May-2009 14:28']We have surveys that we would like to enter in a database and have the report form count the number of "1's", "2's", and so on for a specific period of time.[/quote]

    Clarify....Are you wanting the count in a FORM or a REPORT? Also, how many numbers are you wanting to count? Just 1's and 2's, or many more?
    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>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='lockwoodbf' post='776298' date='21-May-2009 20:28']We have surveys that we would like to enter in a database and have the report form count the number of "1's", "2's", and so on for a specific period of time.[/quote]
    You can probably use a crosstab query and a form and/or report based on it. But without knowing any details it's not possible to- be more specific.

  4. #4
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='teachesms' post='776316' date='21-May-2009 16:07']Clarify....Are you wanting the count in a FORM or a REPORT? Also, how many numbers are you wanting to count? Just 1's and 2's, or many more?[/quote]


    In a report form and includes the totals for 1, 2, 3, 4, and 5 for ten questions

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I don't know that we really answered your question - so:
    It should be fairly straightforward to create a database to track the responses to the 10 questions. Getting the table structure correct is step 1, and that should be pretty simple. A table for questions may or may not be necessary, but would be useful to enforce the entry of the question number in the response table. In the response table you would want to track the value of the response (an integer between 1 and 5), the date/time of the response, and optionally who the responder was if a person may answer the questions more than once over time. Then you can create a report that shows the number of responses of each value for each question for a selected period of time.
    Wendell

Posting Permissions

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