date selection in query : logic needed!
we have one calendar day depending on which the query result is displayed!
Now the requirement is such that when user enters one date the query has to generate the result for the multiple date ranges including the one which he has entered.
example: if user has entered 15/9/2007 then query should not only display the result of the date 15/9/2007 but also the results of -5 to +2 ( means 10/9,11/9,12/9,13/9 and 14/9 plus 16/9 and 17/9 )
simlarly other ranges like -8 to + 7 and so on
How to define this in query?