Challenging?

[Guest]

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.
.........

 

[Joseph Meehan]

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. ........

First you don't want a new table. You may want a query, report or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by adding
a new column in the query called TimeDiff: [ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations if you
like.

 

[Guest]

Thank you, Joseph.
I used DateDiff to calculate time difference.
What I want is to filter only rows that first logon is later than 3 minutes
than and last logoff is 3 minuter earlier.

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. ........

First you don't want a new table. You may want a query, report or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by adding
a new column in the query called TimeDiff: [ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations if you
like.

 

[Joseph Meehan]

Thank you, Joseph.
I used DateDiff to calculate time difference.
What I want is to filter only rows that first logon is later than 3
minutes than and last logoff is 3 minuter earlier.

You should be able to use that formula as part of a formula in the
criteria in the query.

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.
........

First you don't want a new table. You may want a query, report
or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by
adding a new column in the query called TimeDiff:
[ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations
if you like.

 

[Guest]

Thanks again.
Here ia my table.

User Action ActionTime FirsttLogOnTime LastLogOffTime LogOnDiff
LogOffDiff
User1 Logon 10:04:24 10:00 19:00
04:24 -6:53:36
User1 Logoff 18:56:44 10:00 19:00
8:56:44 -3:16
User1 Logon 13:23:34 10:00 19:00
3:23:34 -5:36:25
User2 Logon 11:07:04 11:00 20:00
07:04 -7:52:56
User2 Logon 15:34:23 11:00 20:00
6:34:23 -4:25:37
User2 Logoff 19:52:34 11:00 20:00
7:52:34 -07:26

I want to filter only 1st and 3rd rows. Filter is based on that for each
user (Action = Logon) and (LogOnDiff is smallest positive Number).

And at the same table(query) want to add only 2nd and 6th rows. Filter is
based on that for each user (Action = Logoff) and (LogOffDiff is smallest
negative Number).I I am new to this area>
Pease write down the expressions for me and where I put the expressin.

Thank you, Joseph.
I used DateDiff to calculate time difference.
What I want is to filter only rows that first logon is later than 3
minutes than and last logoff is 3 minuter earlier.

You should be able to use that formula as part of a formula in the
criteria in the query.

Jay wrote:
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.
........

First you don't want a new table. You may want a query, report
or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by
adding a new column in the query called TimeDiff:
[ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations
if you like.

 

[Guest]

User Action ActionTime FirstLogOn LastLogOffT LogOnDiff LogOffDiff
User1 Logon 10:04:24 10:00 19:00 04:24
-6:53:36
User1 Logoff 18:56:44 10:00 19:00 8:56:44
-3:16
User1 Logon 13:23:34 10:00 19:00 3:23:34 -5:36:25
User2 Logon 11:07:04 11:00 20:00 07:04
-7:52:56
User2 Logon 15:34:23 11:00 20:00 6:34:23 -4:25:37
User2 Logoff 19:52:34 11:00 20:00 7:52:34
-07:26

I want to filter only 1st and 3rd rows. Filter is based on that for each
user (Action = Logon) and (LogOnDiff is smallest positive Number).

And at the same table(query) want to add only 2nd and 6th rows. Filter is
based on that for each user (Action = Logoff) and (LogOffDiff is smallest
negative Number).

Thanks again.
Here ia my table.

User Action ActionTime FirsttLogOnTime LastLogOffTime LogOnDiff
LogOffDiff
User1 Logon 10:04:24 10:00 19:00
04:24 -6:53:36
User1 Logoff 18:56:44 10:00 19:00
8:56:44 -3:16
User1 Logon 13:23:34 10:00 19:00
3:23:34 -5:36:25
User2 Logon 11:07:04 11:00 20:00
07:04 -7:52:56
User2 Logon 15:34:23 11:00 20:00
6:34:23 -4:25:37
User2 Logoff 19:52:34 11:00 20:00
7:52:34 -07:26

I want to filter only 1st and 3rd rows. Filter is based on that for each
user (Action = Logon) and (LogOnDiff is smallest positive Number).

And at the same table(query) want to add only 2nd and 6th rows. Filter is
based on that for each user (Action = Logoff) and (LogOffDiff is smallest
negative Number).I I am new to this area>
Pease write down the expressions for me and where I put the expressin.

Thank you, Joseph.
I used DateDiff to calculate time difference.
What I want is to filter only rows that first logon is later than 3
minutes than and last logoff is 3 minuter earlier.

You should be able to use that formula as part of a formula in the
criteria in the query.

:

Jay wrote:
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.
........

First you don't want a new table. You may want a query, report
or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by
adding a new column in the query called TimeDiff:
[ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations
if you like.

 

[Guest]

Thank you Joseph.

Here is my table based on your recoomendation (DateDiff).
User Action ActionTime FirsttLogON LastLogOff LogOnDiff LogOffDiff
User1 Logon 10:04:24 10:00 19:00 04:24
-6:53:36
User1 Logoff 18:56:44 10:00 19:00 8:56:44
-3:16
User1 Logon 13:23:34 10:00 19:00 3:23:34
-5:36:25
User2 Logon 11:07:04 11:00 20:00 07:04
-7:52:56
User2 Logon 15:34:23 11:00 20:00 6:34:23
-4:25:37
User2 Logoff 19:52:34 11:00 20:00 7:52:34
-07:26

I want to filter only 1st and 3rd rows. Filter is based on that for each
user (Action = Logon) and (LogOnDiff is smallest positive Number).

And at the same table(query) want to add only 2nd and 6th rows. Filter is
based on that for each user (Action = Logoff) and (LogOffDiff is smallest
negative Number).
I am new to this area.
Would you please write down the expressions and tell me where I put it in
acess.

Thanks again.
Here ia my table.

User Action ActionTime FirsttLogOnTime LastLogOffTime LogOnDiff
LogOffDiff
User1 Logon 10:04:24 10:00 19:00
04:24 -6:53:36
User1 Logoff 18:56:44 10:00 19:00
8:56:44 -3:16
User1 Logon 13:23:34 10:00 19:00
3:23:34 -5:36:25
User2 Logon 11:07:04 11:00 20:00
07:04 -7:52:56
User2 Logon 15:34:23 11:00 20:00
6:34:23 -4:25:37
User2 Logoff 19:52:34 11:00 20:00
7:52:34 -07:26

I want to filter only 1st and 3rd rows. Filter is based on that for each
user (Action = Logon) and (LogOnDiff is smallest positive Number).

And at the same table(query) want to add only 2nd and 6th rows. Filter is
based on that for each user (Action = Logoff) and (LogOffDiff is smallest
negative Number).I I am new to this area>
Pease write down the expressions for me and where I put the expressin.

Thank you, Joseph.
I used DateDiff to calculate time difference.
What I want is to filter only rows that first logon is later than 3
minutes than and last logoff is 3 minuter earlier.

You should be able to use that formula as part of a formula in the
criteria in the query.

:

Jay wrote:
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.
........

First you don't want a new table. You may want a query, report
or form.

Let's start with the query.

Make a query based on the table and create the TimeDiff field by
adding a new column in the query called TimeDiff:
[ActionTime]-[FirstLogOnTime]

From there you can resort the data and make other calculations
if you like.