In a Query i hav a variable fiscal yera/quarter(range). When ever i enter the range the report must be generated for all the Quarters with in the range. But there is a situation in which if the diffrence between the FROM & TO (Range) is 16(4 Years) Instead of generating the report for each Quarter,The result must be displayed for each Year(between the range).
2001.1 | 2001.2 | 2001.3 |----so on if the difference between the range is <16.
2001 | 2002 | 2003 | 2004 if the difference between the range is = 16.
How can i achieve this .
Thanks in Advance .