Is it possible to view a Query, if we provide only Month & Year..
Then the following result has to display..
Entered month year --- Previous month year --- YTD entered month -- YTD Previous month year
Example : During execution of a query -- suppose if i enter Sep 2007
Sep2007 -- Sep2006 -- YTD Sep2007 -- YTD Sep2006
Please suggest me...
Help will appreciated with points
This is very urgent...
Thanks in advance