Figuring out elapsed time

[schltzy99]

Hi,
I have already did a search, but couldn't find any info on this...

I have an access database that has a open_date (mm/dd/yyyy tt:tt pm/am) and close_date (same format) and would like to get a result that takes the difference between the close_date and open_date to give me the results in time.

Thanks for your help in advance,
Rob
RSchultz
rschultz@insolsys.com

 

[MichaelRed]

Hmmmmmmmmmmm,

given the falibility of 'search' here it is more than possible that the issue exists and your search missed them.

thread701-300744
thread181-55928
thread181-172327
thread222-55210

are four of hundreds of threads I found using "All Words" with "Time" & "difference" searching through threads.

Review threads of your choice add liberal doses of Help files and concoct any number of variations on the theme.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over