Append Query Criteria

P

Procyan

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.
 
J

John Spencer (MVP)

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()
 
P

Procyan

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
 
Top