Results 1 to 2 of 2
  1. #1
    spfleck is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2013
    Posts
    1

    Eliminating records with sequences of numbers

    I have a large database with over 6 million records. Each record has only 7 fields, all numeric.

    I would like to eliminate records that contain fields where the numbers are sequential in at least 4 fields.
    Here's an example:

    1,2,3,4,11,22,43 should be eliminated
    1,22,23,24,25,37,132 should be eliminated

    Can anyone think of an elegant method without manually searching and deleting?

    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    The only ways that come to mind involve a function that would test the values and either return a value or actually delete the record. It would use a counter variable that would either increment or reset depending on whether the values being tested were sequential.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-27-2012, 09:49 PM
  2. Replies: 2
    Last Post: 12-27-2011, 05:42 PM
  3. Eliminating Duplicates in a Report
    By RedWolf3x in forum Reports
    Replies: 5
    Last Post: 10-21-2011, 10:42 AM
  4. eliminating pop up boxes asking for a value
    By REBBROWN in forum Queries
    Replies: 3
    Last Post: 10-13-2010, 11:50 PM
  5. Query to identify sequences of data
    By TheWolfster in forum Queries
    Replies: 13
    Last Post: 05-25-2010, 12:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums