[AccessD] Counts of value ranges

Drew,

You appear to be da man.  I built a little table to hold the ranges, 
then used your SQL statement with the appropriate table and field names 
pasted in and voila, I have counts.  I have to do a little checking of 
those counts to see if they are correct but they "look right".

Drew Wutka wrote:
> Ooops, you would probably want the ranges to show:
> 
> SELECT MinValue, MaxValue, (SELECT Count(*) FROM tblDataTable WHERE
> Value >=T1.MinValue AND Value <=T1.MaxValue) FROM tblRanges AS T1
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, April 24, 2008 8:44 AM
> To: Access Developers discussion and problem solving; Dba-Sqlserver
> Subject: [AccessD] Counts of value ranges
> 
> Guys,
> 
> Is there a way in SQL to get counts of records in value ranges:
> 
> $2,000,000+
> $1 - $1.99M
> $750K - $999K
> $500K - $749K
> $400K - $499K
> $300K - $399K
> $200K - $299K
> $100K - $199K
> <$100K

-- 
John W. Colby
www.ColbyConsulting.com