on 10-20-2008 10:10 AM
Hi Experts,
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 .
Bhargava
Hi Bhargava,
AFAIK there is not any way to achieve this automatically.
You could however just add the year as a free char. The users would then have the possibility to swap the quarters with years.
Hope it helps.
BR
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.