Stumped on grabbing a certain row in a table

okay, here's i'm trying do:

 

i have table holds information based on dates. want able take dates within last 5 minutes...there 4 rows have time within last 5 minutes.  need somehow grab row created first.

 

example of info in table:

name title 3:55pm

name title 4:25pm

name title 4:45pm

name title 4:50pm

name title 4:56pm

name title 4:57pm

name title 4:58pm

name title 4:59pm

 

say time 5:00pm

 

i want able grab row shows 4:56pm.

 

ive stumped myself here...my brain fried.  know how grab of rows under 5 miutes ago, not specific 1 this.

 

thanks help.

if know how select last 4 registers, use top 4 , order

by yourtimefield or whatever , first query gets the

data 4 minutes ago, although more simple solution take

the sort of id.

More discussions in Advanced Techniques

adobe