Challenging?

I have a input table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
User1 Logon 10:04:24 10:00 19:00
User2 Logon 11:07:04 11:00 20:00
User1 Logoff 11:45:34 10:00 19:00
User1 Logon 11:57:55 10:00 19:00
User2 Logoff 12:02:06 11:00 20:00
User2 Logon 12:17:45 11:00 20:00
User1 Logoff 18:53:34 10:00 19:00
User2 Logoff 19:52:34 11:00 20:00
.... ... .... ...
...

I want a output table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
TimeDiff
User1 Logon 10:04:24 10:00 19:00
04:24
User1 Logoff 18:53:34 10:00 19:00
-06:26
User2 Logon 11:07:04 11:00 20:00
07:04
User2 Logoff 19:52:34 11:00 20:00
-07:26

Explain about tables:
There are more than thousand users to log on and off in company's
telephhone system based on their scheduled first logon and last logoff times.
ActionTime field records actual log time including break and lunch time and
other kinds of time.

I want to compare User1's first logon time with actual first logon time,
last logoff time with actual last logoff time only. If user1 logs on later
than 3 minutes after a scheduled FirstLogOnTime or logs off earlier than 3
minutes ahead of LastLogOffTime, output table must caputure these
inconsistent users only. No comparison about break time and other kinds of
time are not necessary at this time. So on User2 and User3. ........


Please, help me with step by step query/programmng instructions.
Really appreciate your helps!!!!

Explain about table:
There are more than thousand users to log on and off in company's
telephhone system based on their scheduled first logon and last logoff times.
ActionTimr field records actual log time including break and lunch time and
other kinds of time.

I want to compare User1's first logon time with actual first logon time,
last logoff time with actual last logoff time. If user1 logs on later than 10
minutes after a scheduled FirstLogOnTime or logs off earlier than 10 minutes
ahead of LastLogOffTime, I need to record these discrepancies. I need a table
that caputures these inconsistent users. No comparison about break time and
other kinds of time are not necessary at this time. So on User2 and User3.
.........

Jay,
Please ask one question in one newsgroup. I have seen similar messages from
you over several news groups. Be patient to see if your first message makes
it to the news group.

--
Duane Hookom
MS Access MVP
--

"Jay" wrote in message
...
I have a input table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
User1 Logon 10:04:24 10:00 19:00
User2 Logon 11:07:04 11:00 20:00
User1 Logoff 11:45:34 10:00 19:00
User1 Logon 11:57:55 10:00 19:00
User2 Logoff 12:02:06 11:00 20:00
User2 Logon 12:17:45 11:00 20:00
User1 Logoff 18:53:34 10:00 19:00
User2 Logoff 19:52:34 11:00 20:00
... ... .... ...
...

I want a output table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
TimeDiff
User1 Logon 10:04:24 10:00 19:00
04:24
User1 Logoff 18:53:34 10:00 19:00
-06:26
User2 Logon 11:07:04 11:00 20:00
07:04
User2 Logoff 19:52:34 11:00 20:00
-07:26

Explain about tables:
There are more than thousand users to log on and off in company's
telephhone system based on their scheduled first logon and last logoff
times.
ActionTime field records actual log time including break and lunch time
and
other kinds of time.

I want to compare User1's first logon time with actual first logon time,
last logoff time with actual last logoff time only. If user1 logs on later
than 3 minutes after a scheduled FirstLogOnTime or logs off earlier than
3
minutes ahead of LastLogOffTime, output table must caputure these
inconsistent users only. No comparison about break time and other kinds of
time are not necessary at this time. So on User2 and User3. ........


Please, help me with step by step query/programmng instructions.
Really appreciate your helps!!!!

Explain about table:
There are more than thousand users to log on and off in company's
telephhone system based on their scheduled first logon and last logoff
times.
ActionTimr field records actual log time including break and lunch time
and
other kinds of time.

I want to compare User1's first logon time with actual first logon time,
last logoff time with actual last logoff time. If user1 logs on later than
10
minutes after a scheduled FirstLogOnTime or logs off earlier than 10
minutes
ahead of LastLogOffTime, I need to record these discrepancies. I need a
table
that caputures these inconsistent users. No comparison about break time
and
other kinds of time are not necessary at this time. So on User2 and
User3.
........

And I've already posted a reply in the Queries newsgroup


--
Message posted via http://www.accessmonster.com