Append Query Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure out how to write a criteria with Access 2003 for this
situation.

I would like my AppendQuery to only pull the data from the record set that
has been modified in the last 10 seconds.

Thanks in advance for anyone that offors information.
 
Do you have a date time field that shows the time of creation and/or the
datetime the record was last modified? If not, I know of no way to do this. If
so, then it should be a simple matter to apply the criteria against the
CreatedDateTime field.

Between DateAdd("s",-10,Now()) and Now()
 
John there are only two words I can say!

YOU ROCK!

It finally works thanks a bunch man.
I hooked a Now() to a command button that ran a macro that SetValue to a
Field in my main form. Then I used an append Query to move the data I needed
to a table. But my query was grabbing everything so thats where I came up
with the idea of needing the filter command you gave.

Take care came thanx again
 
Back
Top