By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Putting Two Related Records in One Row

pravipravi
P: 16
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
Feb 26 '07 #1
Share this Question
Share on Google+
3 Replies


pravipravi
P: 16
Anybody pleas help me to solve out????
Feb 26 '07 #2

Rabbit
Expert Mod 10K+
P: 12,316
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
Feb 26 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
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:
Feb 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.