multiple field, time format.

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

i have a chalange on a file which contains log in times
for agents. I want to get the first log in and the last
log Out time.
i e
ID Num name logInTime LogOut time
61115 john 7:00 Am 7:45 Am
61115 john 7:55 Am 12:00 PM
61115 john 12:30 PM 3:00 PM
61115 john 3:30 PM 5:30 PM
i have a table with Id Num as the key field for each user.
Appriciate any help.
Bob
 
i have a chalange on a file which contains log in times
for agents. I want to get the first log in and the last
log Out time.
i e
ID Num name logInTime LogOut time
61115 john 7:00 Am 7:45 Am
61115 john 7:55 Am 12:00 PM
61115 john 12:30 PM 3:00 PM
61115 john 3:30 PM 5:30 PM
i have a table with Id Num as the key field for each user.
Appriciate any help.
Bob
Click to expand...

Might the user have first logged in on March 8, 2001 and most recently
logged out on January 18, 2004?

If the date isn't an issue, or if you have a date field upon which you
can filter, then a Totals query will do the job. Create a Query
selecting these four fields; change it to a Totals query with the
Greek Sigma icon (like a sideways W). On the newly appearing Totals
row select Group By for ID Num; First for Name (it will pick the name
from an arbitrary record but since presumably all records for an ID
will have the same name it doesn't matter); Min for logInTime and Max
for logOutTime.

If you want to know the span of time in minutes, type an expression

DateDiff("n", Min([LogInTime]), Max([LogOutTime]))

in a vacant Field cell.

John W. Vinson[MVP]
 
Back
Top