How to isolate records based on sequestial numbers

[JJones]

I am trying to create a database that will have records that include dates and a number assigned to that date. ex., the 3rd day of the quarter will be numbered 3 and the 43rd day numbered 43. I will do this via table.

After running a query that will identify a subset of records, I only want to see those records that are part of a 10-day or greater span. There could be multiple 10-day+ spans over a given quarter.



Does anyone have a solution?

Thank you!

[orange]

Interesting, but what is the purpose of the application?

[JJones]

I only want to see records that are within a defined range for consecutive days. Cannot find a formula or ability to view such a subset or definined data in access. Thoughts?