Report Query & Designing

[Amir Ali]

I wana to make report

1 2 3 4 5 .................28 Days of month
00001 John Time in Time Out

In Time in sunday is off so user dont palm there hand and on Sunday its a null record.

So is there any query or any method that I can make this report

[tabreaz]

Can you provide more information, mainly the structure of table?

[Amir Ali]

Yes I Can
Structure of Table are as


Employee_Code Char(8),Time_In Date,Time_Out Date

[tabreaz]

The link might be very helpful.

http://asktom.oracle.com/pls/asktom/...:6923393629227