Somekind of crosstab query (Re-formated)

F

Fadi

Hi All,
Sorry cause my first post wasn't formatted correctly,

Kindly help me on this
i have a table like this one:

ItemName InDate OutDate Amount
--------------------------------------------------------------
Item1 01/09 05/09 7
Item2 03/09 07/09 4

i want a query to get result like the following:


ItemName 01/09 02/09 03/09 04/09 05/09 06/09 07/09 08/09
--------------------------------------------------------------------------------
Item1 7 7 7 7 7 0 0 0
Item2 0 0 4 4 4 4 4 0
--------------------------------------------------------------------------------
(If possible)
Total 7 7 13 13 13 4 4 0


can any one help me on this?

Thanks in advance
 
Top