Time / date Quandry

[A real begineer]

I have an application where my user enters information at supposedly the same time every day. However, due to other issues, they could enter the data any time within about a two hour window.

What I would like to do is compare the data entered now, with data entered yesterday for the same approximate time, and the same day of the week a week previous.

I can work out the yesterday, and last week code. However, I have tried using time based < and > functions and it does not seem to work. If I tell Access that I want the time -1 I get the same time the day before. If I ask it time - 1 hour I get an error code, of various kinds.

All this joy and enlightenment is occuring inside Access 2000.

 

[ericgeil]

Use the dateadd function:

dateadd("h",-1,now())