Re: DateDiff Time
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Sep 2006 23:37:31 -0600
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]
.
- Prev by Date: Re: displaying two query results together
- Next by Date: Re: query for names a - l
- Previous by thread: Re: displaying two query results together
- Next by thread: Re: DateDiff Time
- Index(es):