Calculated value Before & After Date Range

[ragu111]

i have a cross tab query like below

item 2001 2002 2003 2004 2005 2006
-----------------------------------------
item1 500 500 500 500 500 350
item2 300 400 400 400 400
item3 150 200 200 200
-----------------------------------------

if i give a date range from 01-jan-03 to 31-dec-04 i want the query to show as below:

item <2003 2003 2004 >2004
-----------------------------------------
item1 1000 500 500 850
item2 700 400 400 400
item3 150 200 200 200
-----------------------------------------

basically i need to yearly value between the date range and the total of previous and remaining value in seperate columns.

this is an asset report which will be exported from Query to Excel sheet

Ragu

 

[TheAceMan1]

ragu111 . . .

I'm confused! . . . [blue]whats stopping you from doing this in Excel?[/blue]

See Ya! . . . . . .