Select

Try something like this

SELECT    Vare, Destination, DATEDIFF(dd, SendtDato, ModtagetDato) AS NumberOfDays, COUNT(*) AS NumberOfRecords
FROM        dbo.TableA
GROUP BY Vare, Destination, DATEDIFF(dd, SendtDato, ModtagetDato)

Hi Terry,

I don't want to see the 'Varer', but want to see the result like this:

Destination  TotalAfsendt LeveretDag1 LeveretDag2 LeveretDag3
100          200        150        170        199
200          100          80          95        100

So to Dest. 100 there are still one 'Vare', witch isen't delivered - so '199' is just a SUM of the figures to the left.

Rgds.
Kenneth

do you JUST want to see LeveretDag1 LeveretDag2 LeveretDag3
not LeveretDag4 .....?

I want to all columns of LeveretDagX

BUT you cont have columns LeveretDagX! Will see what I can do and get back!

cont  = dont

test