sql - COUNT records in RANGE GROUP BY date -

i have sales table shows date , time of each sale.

for example:

saleid | saledate | saletime
1 | 20110327 | 101
2 | 20110327 | 102
3 | 20110328 | 201

(so sale 2 occurred on 20110327 @ 102)

i need construct single sql statement that:
groups sales date (each row different date) , then
counts sales each time range. (with each time range being separate column)

the table should this:

saledate | 101-159 | 200-259 |
20110327 | 2 | 0 |
20110328 | 0 | 1 |

it needs single statement , saledate , saletime need remain in numeric format.
(i pulling database table several million rows)

i using ms access

any advice appreciated.

thank much!

select saledate, sum(iif(saletime >= 101 , saletime <= 159), 1, 0) [101to159) sum(iif(saletime >= 200 , saletime <= 259), 1, 0) [200to259) mytable group saledate 

note: haven't run query. however, how be.