Posted by Chris on 06/05/05 14:35

Another way of 'saying' that might be

IF jul THEN INCLUDE junjul AND julaug
(in the resultant query)

On Sun, 05 Jun 2005 04:11:25 -0700, Chris <coverland914 @ yahoo.com>
wrote:

>Having a little trouble returning the result I'm looking for in a
>query and thought I'd ask a question here.
>
>I have an input screen with a pull down menu to capture vacation
>activity within a given month as well as capture overlap onto another
>month. For example, if you're taking vacation between June 25 and
>July 4, the input would be 'junjul' if the days off were July 4
>through 10, the input would be 'jul' and if the days off happened to
>be July 25 through August 5, the input would fall under 'julaug' with
>the idea being that the query captures any vacation for the month of
>July but also sends back info for any overlapping month vacation.
>Also, if you did a query for the month of June or August, that
>overlapping vacation would show as well. I did this very effectively
>in Access once and am trying duplicate it with PHP.
>
>So a question becomes, IF jul (is selected in the query for the month
>of July) THEN return any data for junjul AND julaug if they were used
>on the input form and have that data returned under a July query.
>
>Any thoughts?

[Back to original message]