Counting figures between values

[coach32]

My database contains a list of values such as:
2
6
9
15
12
7
4
How do I create a query that will count and show the number of figures between the following values
0 - 7 (Equals 3)
8 - 14 (Equals 2)
15-21 (Equals 1)
Is this possible? Thank you in advance for any assistance.

[JoeM]

Create three calculated expressions to see what range they fall in, then make it an Aggregate Query (summing each expression).
You can do that right in the Query Builder. The resulting SQL Code would look something like this:

SELECT 
    Sum(IIf([MyTable]![MyValue]>=0 And [MyTable]![MyValue]<=7,1,0)) AS [0-7], 
    Sum(IIf([MyTable]![MyValue]>=8 And [MyTable]![MyValue]<=14,1,0)) AS [8-14], 
    Sum(IIf([MyTable]![MyValue]>=15 And [MyTable]![MyValue]<=21,1,0)) AS [15-21]
FROM 
    MyTable;