Unanswered: query db for sequential & non sequential numbers
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....
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):
WHERE N1+1<>N2 And N2+1<>N3 and N3+1<>N4 And N4+1<>N5;