Displaying the Difference Between a Date and Now()

[Guest]

I am using DateDiff to display Total time between and existing date and
Now(). In using DateDiff I would like to display the answer in the format:
Total days elapsed, h:mm time elasped (dd h:mm). Will DateDiff do this or
is there another function I can use? Or is there some form of concatenation
I can use.

Please see my code below:

SELECT MainTable.PGMSSN, MainTable.Batch,
MainTable.DateTimeIn,Format(DateDiff('d',Now(), DateTimeIn)/60,"h:mm:ss") As
TotalTime
FROM MainTable
WHERE (((MainTable.DateTimeOut)=#1/1/1900#));

 

[Duane Hookom]

Try Doug Steele's more complete datediff function at
http://www.accessmvp.com/djsteele/Diff2Dates.html.