Originally Posted by
siapliw
...What I want is D:MM:HH.
Sorry for taking so long to get back to you; in the middle of getting a daughter married and lost track of some threads!
Assumming that D:MM:HH is supposed to be D:HH:MM or Days:Hours:Minutes, this works for me:
Code:
DateDiff("n", [StartDateTime], [EndDateTime]) \ 1440 & ":" & (DateDiff("n", [StartDateTime], [EndDateTime]) Mod 1440) \ 60 & ":" & DateDiff("n", [StartDateTime], [EndDateTime]) Mod 60
I've inserted the Field Names you gave in your last post.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007