Time difference help

[smorgan77]

I need help with datediff in Access. I'm trying to find the difference in time (minutes) between 2 fields and I can't seem to do it. Both fields are formatted as datetime and look like 2/2/2009 8:14:36 AM. How do I get the difference in time (there are over 17,000 records in the table) for each record?

2/2/2009 8:14:36 AM - 2/2/2009 8:30:36 AM

 

[alvechurchdata]

 datediff("n",#2/2/2009 8:14:36 AM#, #2/2/2009 8:30:36 AM#)

gives me 16 as the answer. Is that what you're trying to do?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[smorgan77]

Yes and no. Yes because I want that value, but what I need is to use the field names. I've attached the file.

TriageTime - RoomTime

 

[SkipVought]

datediff("n",[Field1], [Field2])

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[smorgan77]

Thank you Thank you Thank you Thank you Thank you!

 

[dhookom]

between 2 fields .... 2/2/2009 8:14:36 AM - 2/2/2009 8:30:36 AM

what I need is to use the field names

I'm not sure why the field names weren't provided in the first post.

Duane
Hook'D on Access
MS Access MVP