By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,223 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,223 IT Pros & Developers. It's quick & easy.

Trying to sort transactions by time

P: n/a
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?

Feb 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Feb 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.