Timesheet data & report

[leniw]

Hi All,

In the company that I'm working, we have an access control system. Everyweek, we get a very simple report which is like this:

125862 3/9/2012 8:45 Employee1
125863 3/9/2012 16:49 Employee1
125864 4/9/2012 9:35 Employee 3
125865 4/9/2012 16:53 Employee 3

I decide to put theese data in access, in order to design a report that has in the same row the employee, the data and the time_in, time_out.
But I'm stucked...

What I want is a report like:

Employee_3 4/9/2010 9:35 16:53
Employee_1 3/9/2010 8:45 16:49

What I get is a report like:

Employee_3 4/9/2010 9:35
Employee_3 4/9/2010 16:53
Employee_1 3/9/2010 8:45
Employee_1 3/9/2010 16:49

From the few things I know about MS Access, I suppose that since every entry has an ID, I have to find a way to combine everyday's data.... Right???

Is there a solution? Can anyone help me please???

Thank you (very much) in advance,

Lena

 

[SkipVought]

hi,

Use MAX(Time)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Do the time in and out ever span midnight?

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

No, never! / What, never? / Well, hardly ever!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Skip,
I would like to give you a star for the quote alone!

Duane
Hook'D on Access
MS Access MVP

 

[leniw]

Good Morning to All

Thanks for the idea Skip, I will try it!
(No time_in and time_out, are always in the same date)

Thanks again!!

 

[SkipVought]

Yes, it would not be appropriate to pinaone on my post. ;-)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

What are the exact table and field names? You seem to have a sequence type number in your data. Is this unique and always in chronological order?

Duane
Hook'D on Access
MS Access MVP