P
Porky
Scenario: login/logoff scripts that kick username, times, and dates out
to a CSV file. I have a linked table in access pointing to that CSV
file. Users typically log in and log out twice a day (they are required
by company policy to log out when they go to lunch).
Problem: I am trying to figure out a way to check when they logged in
first thing in the morning. Certain performance bonuses are based on
whether or not they logged into their systems before 8am (once again,
company policy). This needs to count the number of times they are
"late" (logged in after 8am) per week, and add it up for the month
(queries are typically on the calendar month). It would be great if it
could simultaneously go back and report on the late times for the
previous calendar quarter as well.
Thanks.
to a CSV file. I have a linked table in access pointing to that CSV
file. Users typically log in and log out twice a day (they are required
by company policy to log out when they go to lunch).
Problem: I am trying to figure out a way to check when they logged in
first thing in the morning. Certain performance bonuses are based on
whether or not they logged into their systems before 8am (once again,
company policy). This needs to count the number of times they are
"late" (logged in after 8am) per week, and add it up for the month
(queries are typically on the calendar month). It would be great if it
could simultaneously go back and report on the late times for the
previous calendar quarter as well.
Thanks.