Hello Everybody,

In Excel it is possible to make a crosstabel with advanced group
by-functions.

You can insert where you want to start, where you want to finish and the
interval. 

I like to do the same in Access 2000. But I don't know how to do this. 

For example:

The brondata is:

Doorlooptijd 
69 
51 
22 
22 
22 
22 
22 
22 
20 
15 
14 
14 
13 
10 
8 
7 
5 
5 
5 
5 
5 
4 
3 
3 
3 
3 
3 
3 
3 
3 
3 
3 

This is what I want to know (can I do this with a query???)
Doorlooptijd   Total 
0-5              15 
6-10              3 
11-15             4 
16-20             1 
>21               8 

Who helps me?

Thanks before!

hendrik