Log In tables

[Jacqueline]

I am working on a simple database that track students log in and log out
times. Does anyone have a DB set up to do this before I try to reinvent the
wheel? I know Access and SQL, but very limited in VB. (taking a class this
quarter)

Thank you

 

[John Vinson]

I am working on a simple database that track students log in and log out
times. Does anyone have a DB set up to do this before I try to reinvent the
wheel? I know Access and SQL, but very limited in VB. (taking a class this
quarter)

Thank you

No VB should be needed, I wouldn't think. Just two tables and a form
with a subform:

Students
StudentID
LastName
FirstName
<other bio information>

Logins
StudentID <<<
Login Date/Time <<< joint two-field Primary Key
Logout Date/Time

A Form based on Students, with a subform based on Logins, would let
you enter this information.

John W. Vinson[MVP]

 

[Jacqueline]

John,
This is exactly what I started with, but the IN and Out times for the same
date end up as seperate records. This makes it difficult to calculate the
time between the in&out on the same date.

Solutions?
Thanks

 

[John Vinson]

John,
This is exactly what I started with, but the IN and Out times for the same
date end up as seperate records. This makes it difficult to calculate the
time between the in&out on the same date.

Solutions?
Thanks

Well, I was assuming that the user would return to their signin record
in order to sign out. Is it ever possible that a user would sign in
before midnight, and leave after midnight the same night (a different
date)? You may need some additional complications here!

John W. Vinson[MVP]

 

[Jacqueline]

John,
You are right, something I had not thought of, they would sign in and out on
the same day, but they can sign in & out several times during the same day?

Am I making it too hard by seperating the time from the date?
thanks

 

[John Vinson]

John,
You are right, something I had not thought of, they would sign in and out on
the same day, but they can sign in & out several times during the same day?

Ok, you'll need to either store each signin and signout in the same
record, or have some fairly inefficient queries to match each signout
with the most recent previous signin.

Am I making it too hard by seperating the time from the date?

Yes. Access Date/Time values are actually stored as numbers, a count
of days and fractions of a day (times) since midnight, December 30,
1899. As such, any pure Time value corresponds to a time on that
long-ago date, and it becomes much harder to determine "the most
recent".


John W. Vinson[MVP]

 

[Jacqueline]

Thanks John, I will re-think the table. As usal I thought of the hardest way
to accomplish my task first!
Thanks for the help to get me thinking right