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:
 
Back
Top