Hello Everyone,
I am trying to build a query in MS Access, I would like to be able to
subtract a set amount of minutes from the Now() function. What I'm
trying to do is be able to say:
New Time: Now() - [Minutes] for example is Now() is 2/21/2006 9:04:08
PM and Minutes is equal to 3 the result would be 2/21/2006 9:01:08 PM.

Can someone help me with this?

Thanks

joeserrone@hotmail.com wrote:[color=blue]
> Hello Everyone,
> I am trying to build a query in MS Access, I would like to be able to
> subtract a set amount of minutes from the Now() function. What I'm
> trying to do is be able to say:
> New Time: Now() - [Minutes] for example is Now() is 2/21/2006 9:04:08
> PM and Minutes is equal to 3 the result would be 2/21/2006 9:01:08 PM.
>
> Can someone help me with this?
>
> Thanks[/color]


NewTime: DateAdd("nn", -3, Now())

?

--
regards,

Br@dley