Help with Function/Query to find sequential numbers 1

[dkmansion]

(I've dual posted this in Access Queries also...)
My problem is this..

I now manage phone numbers for an institution and need to identify sequential numbers in a table. tblNumbersfldPhoneNumber...and other fields)

The issue is sometimes I need to identify 3 sequential #s sometimes 4 sometimes 10. So the ability to have the tool/Function/query return the number of sequentials I request would be great.

Are there any Ideas along this line?


Donald M

 

[Remou]

See
Help with Query/Function to find sequential numbers
thread701-1241781
For both SQL and code ideas.