 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007Calculating time in query
Hi there, I'm searching for some help with my query. I'm making access to be my administration program for my freelance job. I've made a table with a row 'starttime' and a row 'endtime'. Now in my query I want to calculate the difference between these two rows. And then I want to make another query to calculate the totals of these differences. Is this a logic way to do this? And I'm trying to make a expression to calculate the difference but with no luck. The result is something like this: 3,2515785. I've found a kb article but I still can't figure it out because I don't know how to use VB. I hope someone can help me with the expression and can judge if above is a logic thing... Thanks in advance! Roy > Hi there, > [quoted text clipped - 14 lines] > > Roy There are several articles on working with dates and times in Access at the following URL ... http://www.mvps.org/access/datetime/index.html  SignatureBrendan Reynolds It all starts with the data (design) in Access. How is it that you have one row holding (something's) [starttime] and a different row holding (?that same something's?) [endtime]? Wouldn't start and end times be related to the same something? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > Hi there, > [quoted text clipped - 13 lines] > > Roy This table has a field with a unic ID, a field with a menu linked to a project table so that a can pick the name of the project, a field for the starttime, a field for the endtime and a commence field. And I thought that a can make the calculating in the query. Hope a bit clearer :-) Roy > It all starts with the data (design) in Access. > [quoted text clipped - 24 lines] >> >> Roy Your original post mentioned calculating the difference between two rows. This description sounds like you want to calculate the difference between two fields. Check the lead that Brendon provided. SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > This table has a field with a unic ID, a field with a menu linked to a > project table so that a can pick the name of the project, a field for the [quoted text clipped - 33 lines] > >> > >> Roy Hi Jeff, Thanks for you reply. I can't find the lead of Brendon? Is it in this group? Greetz Roy > Your original post mentioned calculating the difference between two rows. > This description sounds like you want to calculate the difference between [quoted text clipped - 48 lines] >> >> >> >> Roy Brendan Reynold responded to your posting. There are several articles on working with dates and times in Access at the following URL ... http://www.mvps.org/access/datetime/index.html SignatureBrendan Reynolds -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . > Hi Jeff, > [quoted text clipped - 58 lines] >>> >> >>> >> Roy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.