Putting Two Related Records in One Row

[pravipravi]

Hello everybody,

I have a Attendance table, which has columns Date. ShiftInTime, ShiftOutTime, EventTime, Login_Type.

Now for every EventCode= "I" or "O" there are two records. That means for a day say 07/10/2006 as Workdate there are two records like,

EmpID Date EventTime EventCode
1 07/10/2006 9:00 I

1 07/10/2006 17:15 O

NOW.. I want a report in Table or Crystal report which will have a single record for a single Workdate..as folllows

EmpID WorkDate ShiftInTime ShiftOutTime InTime OutTime

1 07/10/2006 09:00 17:00 9:00 17:15

Can you please help me out..I'm usng

[pravipravi]

Anybody pleas help me to solve out????

[Rabbit]

Please do not bump a thread only after 5 hours. The experts on this forum are volunteers who are using their free time to help others. If you have not received a response after 24 hours, then feel free to bump the thread.

In related news, you have yet to reply to your other thread.

MODERATOR

[NeoPa]

You may want to consider rereading you question as well. I tried to read it then gave up when it seemed to stop in the middle of a sentence :confused: