Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Unanswered: query db for sequential & non sequential numbers

    Hello everyone,

    1st plz accept my appoliges if this situation already has been posted and replied but I did search the forums but didnt get a solution.

    this is my problem. I have a table with aprox. 2k records, this table has 5 fields + ID. about 50-60% of the records have sequential numbers (1 2 3 4....) and the remaining non sequential numbers ( 1 3 5 7....). Im trying to make a query by selecting all fields + ID as follows:

    * show all records only with the sequential nbrs
    * show all records only with the non sequential nbrs
    * show all records with a pre-determined nbrs, i.e., show records with each 5 or 10 space between numbers (1 5 10 15 20)

    is this possible? and if so, please help me. i going mad trying to figure this out....

    Thank you.

  2. #2
    Join Date
    Mar 2007
    Posts
    2
    Hello,

    Besides using the query system fm Access and looked to the SQL window and in 30 minutes managed to do what i wanted. For curiosity, here is the solution to show all records only with the non sequential nbrs (Table1, N1...N5=columns):

    SELECT *
    FROM Table1
    WHERE N1+1<>N2 And N2+1<>N3 and N3+1<>N4 And N4+1<>N5;

    Regards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •