Timestamp Criteria in Query

  • Thread starter Thread starter jfredel via AccessMonster.com
  • Start date Start date
J

jfredel via AccessMonster.com

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.
 
jfredel said:
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.
Click to expand...


I think this criteria will do that:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Timestamp 1
timestamp handle 5
Subtracting timestamps 2
Missing records using a timestamped field to query. 5
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD 3
Access Dcount (multiple criteria) 3
Create Query to determine if employee is currently punched out or 4
Write conflict 1

Back
Top