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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 2007:Calculating time elapsed based on a date
Hey Guys, Thanks for your help. JBinQLD your code worked perfectly! I've spent 2 days looking through all sorts of forums looking for an answer.- Evilyvy
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007:Calculating time elapsed based on a date
Hi all, I am new to access 2007 and I am trying to create a field in a query that will return total elapsed hours worked based on their hire date. This returns total days: Hours Worked: Int(DateDiff("d",[Vendors]![Hire Date],Date())) Is there a way to format this into hours?- Evilyvy
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
