Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JoyousL

  1. JoyousL

    Using Hour Data Within a General Date

    OK, so I created a query with the code that you sent, and I am pretty sure that it is now pulling the time, and giving me the total hours worked. Thank you for all of your help. I need to spend some time with this, and get my head around it. Joy
  2. JoyousL

    Using Hour Data Within a General Date

    I couldn't find the entry that I cut that from...but here is another example: TimeIn = 3:14 TimOut = 3:14 Sum = 3.472E-05 but if I wait a little longer: TimeIn = 3:16 TimOut = 3:18 Sum = .00125
  3. JoyousL

    Using Hour Data Within a General Date

    Skip, I'm still having some trouble with the "sum". So, let me explain how I have my data set-up, and how I am populating my form. I have the following table: tblClockIn PunchInID (auto number) EmployeeID (Linked to a main employee info table) TimeIn (formatted as General Date to show Date...
  4. JoyousL

    Using Hour Data Within a General Date

    Again, sorry for being so new at this. I understand what the code is going to do as far as formatting, and the sum command etc. However, I'm still not sure where to put it. Would I place this code in a query, or in an after update event for the total hours field on my form...? Joy
  5. JoyousL

    Using Hour Data Within a General Date

    I am learning as I go, and I'm still trying to figure this part out... would you mind going into a little more detail on where I should use this information? Thanks! Joy
  6. JoyousL

    Using Hour Data Within a General Date

    I am creating an hour tracking program for employees to "clock-in" and "clock-out". The forms and tables are complete, but I’m having trouble with the date/time data. On my clock-in/clock-out forms, users click a button, and a field is populated with the current date and time. I have formatted...
See more

Part and Inventory Search

Back
Top