Robert L. Stewart
rl_stewart at highstream.net
Tue Oct 14 10:51:07 CDT 2003
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