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.