Timestamp Criteria in Query

From: "jfredel via AccessMonster.com" <u10039@uwe>
Date: Thu, 18 Jan 2007 21:51:59 GMT

I have a query that needs to pull data from records that have been updated in
the last 10 minutes. I have a field that is set to NOW()when updated.
Cannot figure out what to put in the criteria of my timestamp field to pull
records where the timestamp is within 10 minutes of when I run the query.

Any help would be greatly appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200701/1

.

Follow-Ups:
- Re: Timestamp Criteria in Query
  - From: Marshall Barton

Prev by Date: Re: problems with exporting query to excel
Next by Date: Help with Date Query and Report
Previous by thread: Re: Update Query Replacing text within HTML code Conversion Failure ER
Next by thread: Re: Timestamp Criteria in Query
Index(es):
- Date
- Thread

Relevant Pages

RE: Eloquent Programming
... Presuming that all users are in one database, each ... hidden text box on the form and use the hidden text box in the query. ... I have one form/query for each department (24 forms/queries ... > like to know how to do is this, pull data from a specific query for this one ...
(microsoft.public.access.modulesdaovba)
Re: From Date x to Date y (Query table data)
... > Criteria of the date field in the query, ... The query we are creating will pull data ... and several queries for all the different time frames. ...
(microsoft.public.access.queries)
Re: Eloquent Programming
... > I'm looking for an eloquent way to pull data from multiple queries based ... > I have a database I created to track training for multiple departments and ... > currently I have it set up to open a form/query based on an individuals ... > pull data from the HR query. ...
(microsoft.public.access.modulesdaovba)
From Date x to Date y (Query table data)
... I am wondering if it is possible to use a query to pull data from a table, ... you could use the same exact query (or a report based ... and several queries for all the different time frames. ...
(microsoft.public.access.queries)
Re: Eloquent Programming
... Seems to me you should be able to do this with one query, ... department and the userID as criteria. ... Access Database Samples: www.rogersaccesslibrary.com ... > I'm looking for an eloquent way to pull data from multiple queries based ...
(microsoft.public.access.modulesdaovba)