Re: DateDiff Time

Tech-Archive recommends: Speed Up your PC by fixing your registry



On Sun, 10 Sep 2006 22:14:01 -0700, blink
<blink@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello,
I'm trying to get a DateDiff expression in a query to result the subtraction
of time2 and time1, but when in the query the result doesn't showup until its
clicked and is negative. Here is the expression DateDiff ("n", [time1],
[time2]) . I'm a newb at access so any info would greatly appreciated.

Where are you putting the expression? What is it you're "clicking"?

DateDiff("n", [Time1], [Time2]) will subtract Time1 from Time2.

John W. Vinson[MVP]
.