N
nl
Start time- End Time, how to get the duration in a query or report using and
expression???
expression???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve
D
Daniel Pineault
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.
--
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
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/
__________________________________________
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/
__________________________________________