Pie Chart report based off count of items less than a number and greater than a number

[NeoFax99]

I would like to create a report that contains a pie chart that shows
how many forms were processed less than 30 days, between 30-90 and
greater than 90 days. So, for example I have a table that contains the
submit dates for each form running throughout our company. I have a
query that calculates the difference between then and now. However, I
do not know how to create a field that counts how many are between 0
and 30, between 31 and 90, and greater than 90.

 

[Van T. Dinh]

Check Access VB Help on the Switch() function to switch < 30 to , says, 1;
30 to 90 to 2 and > 90 to 3 and then group by the results (1, 2, 3) on the
Switch function.

BTW, for accounting purposes, AFAIK, it is usually divided into 4 groups:
* < 30
* 30 to < 60
* 60 to < 90
* 90 and over

 

[NeoFax99]

Thanks! That worked great!

Check Access VB Help on the Switch() function to switch < 30 to , says, 1;
30 to 90 to 2 and > 90 to 3 and then group by the results (1, 2, 3) on the
Switch function.

BTW, for accounting purposes, AFAIK, it is usually divided into 4 groups:
* < 30
* 30 to < 60
* 60 to < 90
* 90 and over