Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Assistance needed with Query "If Then"

    I am having trouble with a query. I have attached a simple version of a table for your perusal. I think the solution is relatively simple, but I don't know how to do it. What I want to do is this:

    If a person has any stays of shorter than 3 days, I want the results to show their entire history regardless of the lengths. If the individual does not have any stays of 3 days or shorter, I want the results to skip them completely.

    Please help. A detailed response will be beneficial as I really am a novice and need a step by step walkthrough.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2004
    Build a query

    In the length criteria place <3

    When you run the query you will have every length of stay less than 3 days

    to add to the output effect make a report based on the query and set the sort group to the NAME field


Posting Permissions

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