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.hughes@fns.usda.gov wrote in
news:1140553805.916300.226000@o13g2000cwo.googlegr oups.com:
[color=blue]
> 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?
>[/color]

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.