Hi all,

I have a table with stock movements with all IN entries and OUT entries from several years, my back end is sql server, now i need to create a select statement that i can have this layout,

   Date     Description         Out     In   Stock
            Total Later Years  1000   1500     500
01.01.2006    IN                       500    1000
07.01.2006    OUT               100            900 
12.03.2006    IN                        50     950
...
...

But in the first line i need to count all the movements from the last years. Any chance to acomplish this with only one SELECT.

Thank's

João Batista