|
|
Posted by Chris on 06/05/05 14:11
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?
Navigation:
[Reply to this message]
|