[AccessD] Re: Report Grouping

I believe that you can do this with a query.

Use GroupBy on the Center
Use Min on the Center range in the first instance of it
Use Max on the center range in the second instance of it.

But, it sounds like she simply wants a grouping report
grouped by Center and sorted by center then center range.

Robert

At 10:24 AM 10/14/2003 -0500, you wrote:
>Date: Tue, 14 Oct 2003 11:13:04 +0200
>From: Gustav Brock <gustav at cactus.dk>
>Subject: Re: [AccessD] Report Grouping
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <5211452017.20031014111304 at cactus.dk>
>Content-Type: text/plain; charset=us-ascii
>
>Hi Gina
>
>Assuming that
>
>   STALLWORTH - 1080400000
>   CHS - between "108175*" and "108176*" or like "40811*"
>   VCHA - between "108100*" and "108210*"
>
>should be something like this as no ranges overlap:
>
>   STALLWORTH - 1080400000
>   CHS - between "108175*" and "108176*" or like "40811*"
>   VCHA - between "108100*" and "108120*"
>
>you could create a table with the specific ranges:
>
>Center      AreaMin         AreaMax
>CHS         1081750000      1081769999
>STALLWORTH  1080400000      1080400000
>VCHA        1081000000      1081209999
>CHS         4081100000      4081199999