>Maybe this will stretch your imagination:
>Millions of records in the table. Each record has at least 3 fields that can hold over 20,000 possible values. The records tie back to a parent table in a many-to-one relationship. We need to retrieve records based on the presence or absence of myriad combinations of those 20,000 different values (which are an indication of health status and treatments). Welcome to the world of clinical software, which is substantially different from the analytical needs of the retail sector.

I got amazed with your clinical analysis. But by the way these problems should be resolved step by step:
1. Your write just one generic procedure which accept parameters: field name and up/low limits.
2. Your run this procedure (one SQL statement with Where BETWEEN(&fieldname..) ahd get cursor.
3. Then you change your parameter and call the same procedure again against new created cursor.
4. Then you get understanding that some called loop would be helpful and we got a program to create multiple reports.
By the way besides retail community I worked for some nice financial giants so your problems are not new for me.
Don't mind about all this staff and have good weekend!