How do I get a Sign In/Sign Out form to log the current date and t

S

stacey

This is for a volunteer group at our local shelter so any help will be
greatly appreciated. I have created a form that the volunteer will choose
their name from a dropdown box and then I've created a Sign In and a Sign Out
button. I need to know how to get those buttons to log the current date and
time.

Also, I need to create a query that will calculate the time between sign in
and sign out?
 
A

Arvin Meyer MVP

Add a Date/Time field to the underlying Login table. Set its DefaultValue
to:

=Now()

Set the format to show the date and time. As each record is entered, it's
date and time will fill in automagically.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link two subforms in datasheet view (one sub-form, one sub-subform 1
Invalid argument (cannot open sign in) 2
sign-out end of day time date 2
Update form 3
record the sign on 2
Open another form if field checked in one form 1
How do I password protect a form field? i.e. signature field 1
How do I lock form for users except boss to review and sign 1

Top