N nl Dec 18, 2009 #1 Start time- End Time, how to get the duration in a query or report using and expression???
S Steve Dec 18, 2009 #2 Look at the DateDiff function in the Help file. Steve (e-mail address removed)
D Daniel Pineault Dec 18, 2009 #3 Take a look at the DateDiff() function. It will do exactly this for you. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful.
Take a look at the DateDiff() function. It will do exactly this for you. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful.
T Tom Wickerath Dec 20, 2009 #4 See the section sub-titled "Perform calculations that use date and time values", towards the bottom of this document: Using dates and times in Access http://office.microsoft.com/en-us/access/HA010546621033.aspx Also, check out this document: On time and how much has elapsed http://office.microsoft.com/en-us/access/HA011102181033.aspx Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________
See the section sub-titled "Perform calculations that use date and time values", towards the bottom of this document: Using dates and times in Access http://office.microsoft.com/en-us/access/HA010546621033.aspx Also, check out this document: On time and how much has elapsed http://office.microsoft.com/en-us/access/HA011102181033.aspx Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________
