Results 1 to 3 of 3

Thread: Query Question

  1. #1
    Join Date
    Nov 2004

    Unanswered: Query Question

    I have a database that has been created through FrontPage2003 for a survey that was created. The survey takes the users answers and puts them into the the database. The answers are stored as text, but are numbered from 1 to 5. I would like to know if there is a way to query the answers in the database so that I can view all the answers that are greater than 3 and less than 3. I have attached a sample database similar to my survey database. Any help would be greatly appreciated. Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    In general you're going to use a criteria of:

    < 3 AND > 3

    If you're using sql that would go in the where clause, or the criteria section if you're using the designer.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004

    That doesn't work

    Once I enter <3 And >3 for field 1, all I get is one row. I need that criteria for all the fields, 1-10.

Posting Permissions

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