Trying to sort transactions by time

[bob.hughes]

I'm trying to write a query that will find multiple transactions that
take place within a pre-determined time limit. I can easily compute
the time between adjacent transactions and then judge whether they fall
within the time limit, but I can't figure out a way to do this for
three or more transactions. Does anybody know how to do this?

[Bob Quintal]

bo********@fns.usda.gov wrote in
news:11**********************@o13g2000cwo.googlegr oups.com:

I'm trying to write a query that will find multiple
transactions that take place within a pre-determined time
limit. I can easily compute the time between adjacent
transactions and then judge whether they fall within the time
limit, but I can't figure out a way to do this for three or
more transactions. Does anybody know how to do this?

Create a query that contains (at least) the following fields: 1)
PrimaryKey of table, 2)the time you wish to evaluate, 3)
calculated value of time + time limit.

Create a new query that takes your first, and the original
table.

Set the criteria for the time from the original table to
BETWEEN [query].[original time] AND [query].[calculated time]

Run the query. see the results.
--
Bob Quintal

PA is y I've altered my email address.