I am trying to create a report where i list in the first column a number range for example 80000 to 89999, and then pull from a table any record matching the first column and and name associated with it.
My purpose is to create a list of available numbers in that first range, and see who may be assigned to that number if that is the case.
Here is an example of what I'm looking for
80000
80001
80002 Jane Doe
80003
80004 John Doe
Is this possible?