Please read my previous post carefully. You've to complete step 2 by yourself.
>
>The query result is differ that I post.
>Your query result displays THREE columns report but I need FIVE columns as
>
>----Date-------|-In-|-Out-|--In-|-Out-|
>15-01-2008-|-30-|-230-|--0-|-----0-|
>16-01-2008-|-30-|-130-|--0-|-----0-|
>17-01-2008-|-40-|-140-|-40-|-140-|
>18-01-2008-|-50-|-150-|-50-|-150-|
>
>Please help again
>
>
>
>
>
>
--sb--