Query Help

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a database that tracks items that pass trough certain points. Every
transaction is stored in a single table. I need a query to look at each
record and see if there is another record in that table that occurs within a
designated time frame. ie 20 minutes.

The field names are time and ID#

Any ideas on how to search all records in this database and determine which
ones are matches?

Thanks
 
Brent said:
I have a database that tracks items that pass trough certain points. Every
transaction is stored in a single table. I need a query to look at each
record and see if there is another record in that table that occurs within a
designated time frame. ie 20 minutes.

The field names are time and ID#

Any ideas on how to search all records in this database and determine which
ones are matches?
Click to expand...


Another one of your multi-posted questions. People are
going to get tired of seeing all these copies of the same
question and won't be able to keep track of the various
threads you have going.

See http://www.mvps.org/access/netiquette.htm
for hints on how to use newsgroups effectively.
 
Back
Top