Records Elimination depending on Time difference

  • Thread starter Thread starter John via AccessMonster.com
  • Start date Start date
J

John via AccessMonster.com

There are two fields in a table i.e. Time, Name.
I want to eliminate records where the Time difference for any record is less
than 10 seconds. This is required to overcome the problem of duplicate
entries. Please help in this regard.
 
Where does the time diffence come from? Is it the value of the field or the
difference betwen the value of the field from 1 record to the next?

If it's the value of the field do a Delete query and set the criteria to
less than 10 (assuming your entries are in seconds) Suggest you back up your
data 1st!

Sheila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acnewrec? 1
searching unmatching records 1
Delete Multiple records 2
Duplicate records - eliminate from totals 11
query to eliminate duplicate records 1
Delete duplicates based on time 2
Access Compare records in same access table 0
Access Access - Elapsed Time between Records 5

Back
Top