time calculation in access

  • Thread starter Thread starter rowedf
  • Start date Start date
R

rowedf

hello,

I am really having a hard time in access. I do not know how to write
using the sql view so I use design view. I have two time fields
"dispatch time" and "arrival time". I am trying to find out the
elapsed time in minutes. I am trying to use the DateDiff function in
design view but I am getting compile errors..what am I doing wrong or
what other way can i figure this out? Here is what I have currently:

ElapsedMins: DateDiff("n",[Dispatch time],[Arrival Time])

When I run that I get a Compile Error. In query expression
DateDiff("n",[Dispatch time],[Arrival Time])

Thanks for any help.


rowedf
 
Try this:

ElapsedMins: Format([Dispatch time] - 1 - [Arrival
Time], "n")

jmonty

-----Original Message-----

hello,

I am really having a hard time in access. I do not know how to write
using the sql view so I use design view. I have two time fields
"dispatch time" and "arrival time". I am trying to find out the
elapsed time in minutes. I am trying to use the DateDiff function in
design view but I am getting compile errors..what am I doing wrong or
what other way can i figure this out? Here is what I have currently:

ElapsedMins: DateDiff("n",[Dispatch time],[Arrival Time])

When I run that I get a Compile Error. In query expression
DateDiff("n",[Dispatch time],[Arrival time])

Thanks for any help.


rowedf
---------------------------------------------------------- --------------
----------------------------------------------------------
Click to expand...
Click to expand...
 
uh oh...im still seeing some errors...some aren't calculatin
right.....the majority do work fine but there are some that isnt givin
the right result? It seems to be the ones that are exactly 60 minute
elapsed time

rowed
 
Back
Top