Hello,

I have a table of records where each record is identified by a unique check number. I need to print out this list of checks but it is >90,000 records. I don't really need to look at 90,000 individual records. All I need to know is the ranges of the check number.

The table, pretending that it only has the one check number field, looks like this:

Check Number
1
2
3
4
5
7
8
9


10

And I just need to know this:

Check Number Range
1-5
7-10

(note that check number 6 is missing from my table and that will be indicated by a break in each sequential range of check numbers that are in the table).

Is there any trick in Access that could yield these results? Searching help under "range" and "continuous" did not help me.

Thanks!!