Re: Timestamp Criteria in Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

jfredel via AccessMonster.com wrote:

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.


I think this criteria will do that:

>DateAdd("n", -10, Now())

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: IF statement using numerical expression with a text result
    ... [MVP - Microsoft Word] ... I have three criteria that have been tested with Pass/Fail results. ... text form fields to gather the original data but I am not using a form field ...
    (microsoft.public.word.tables)
  • Re: multiple OR criteria
    ... ElseIf CurrentProject.AllForms.IsLoaded THEN ... Then in the query change the where clause to ... criteria if none of the forms is open OR if the value returned by the control ... Access MVP 2002-2005, 2007-2009 ...
    (microsoft.public.access.queries)
  • Re: concatenate type mismatch error 13
    ... criteria. ... > Brendan Reynolds (MVP) ... >> I'm trying to concatenate two strings but it just doesn't seem to be ...
    (microsoft.public.access.forms)
  • Re: Query Help!
    ... "John Spencer MVP" wrote: ... Create a query with your date field and then apply criteria to return any ... Access MVP 2002-2005, 2007-2009 ...
    (microsoft.public.access.queries)
  • Re: Congrats to Pedroia
    ... Was he the MVP? ... At times Howard was an afterthought. ... There is a set of criteria for the MVP award which points it more ...
    (rec.music.artists.springsteen)