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

  • Thread starter Thread starter NeoFax99
  • Start date Start date
N

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.
 
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
 
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
Click to expand...
 
Back
Top