Now minus 16 hours???

[GoodLife22]

I have a field in my tbl [DateAdded] which is automatically given a date/time stamp when a new record is created in my table.

I want to make a simple query which will show me all records entered in the system over the past 16 hours. I am not sure how to write the query criteria

so I want something like:

>Now() - DateAdd("h", -16, [DateAdded])

So if I run my query I want to see all record entered into the system within the past 16 hours based on the time stamp in [DateAdded]

Thank you all.

 

[Brianwarnock]

Use Between... And

Between Dateadd("h",-16,Now()) And Now()

as the criteria for Dateadded

Brian

 

[Brianwarnock]

On reflection you could just have criteria of

> Dateadd("h",-16,Now())

Brian

 

[GoodLife22]

that worked perfect. So simple. Thanks.