Hi sergey,


The final result is :
www.amline.be\finalresult.jpg


the structure tables is :
www.amline.be\boundtable.jpg

I prepare a table for a cross table but it does not function
WWW.Amline.be\cross.jpg


Each employee can have 2 pauses per day.

Thank in advance





>Bernhart,
>
>Would this work for you?

SELECT iEmployee, DAY(ddate) as iDay, cNomp ;
>  FROM tpsh ;
>  WHERE cNomp <> SPACE(2) ;
>  ORDER BY 1,2 ;
>  INTO CURSOR crsCrossTab
>

>>
>>
>>I have cursor with :( see on the picture)
>>
>>WWW.Amline.be\cross.jpg
>>
>>I want
>>
>>

>>iemployee    1  - 2  -  3  -  4  -5  - 6  - 7 - > 31
>>99          '  ' '  '  'JF'
>>99          '  ' '  '  'K1'
>>

>>
>>What sql Command can i do with for this result ?
>>