Count records by ranges

[mjhopler]

Attached is a one table database. I have properties listed by the NOI_DSCR. I want to create specific ranges of NOI_DSCR and get a count of how many properties are in each range. Below is an example of the desired results. I have not clue where to even start on this one. Any help is greatly appreciated.



It is difficult to show the results below, The data before the colon is the first field and data after the colon represents the second field. This is the best way I know to show it and figured a visual example would help explain.

Desired Results
Range: Property Count
< 0.5: 6
.5 to 0.99: 2
1.0 to 1.19: 0
1.20 to 1.39: 3
1.40 to 1.59: 9
1.60 to 2.00: 6
> 2.00: 7

Thanks in advance

[mjhopler]

I made a bit of head way. I have been able to create a query that has all the data needed and created a union query that pulls the data together. However, I lost my query formatting in the Union Query results. Is it possible to format the query results with a union query?

[mjhopler]

Solved my self. added code to the SQL.

Format(Expression,"format")