Calculating dates based on two dates from 24 hours
in [General]
|
Prev: How to construct a hierarchy from a list? (Access 2003)
Next: Access 2010 very slow with Sharepoint 2010
From: Alaska1 on 27 May 2010 15:55 I have two dates in my database. I need to start to write and track a report from the second date 24 hours after the first date. I need to report on the time frame it takes to return packets. They are supposed to be returned in a 24 hour period.
From: Wayne-I-M on 27 May 2010 17:04
Hi There is a really good funtion here (just tried them both and I personally like the 2nd one as it gives a clearer result) http://office2010.microsoft.com/en-gb/access-help/on-time-and-how-much-has-elapsed-HA001110218.aspx?CTT=1&origin=EC001022701 just use dateadd to add 1 day to your first time/date and then call the funtion in a query - you can then use the resorts in a form or report HTH -- Wayne Manchester, England. "Alaska1" wrote: > I have two dates in my database. I need to start to write and track a > report from the second date 24 hours after the first date. I need to report > on the time frame it takes to return packets. They are supposed to be > returned in a 24 hour period. |