I’m trying to write a query for a monthly report.

The table that I’m using has the following fields; CASE_ID, DISTRICT_OFFICE, TOTAL_ARREARS_ON_CASE.

I want the monthly report to tell me how many cases (count) in each DISTRICT_OFFICE have arrears (1) between 100-5000 (2) between 5001-10000 (3) 10001-15000.

Can this be done in one query and can you please show me how to write it?

Hi Mike,

I've written the queries in for you so that you can have a look and you'll be able to use these on a report - I've put them in form view so that you can see at a glance what's what.

Hope it helps.

Thanks,

Donna :)

Thank you Donna. I wanted to know the number of cases for each DISTRICT_OFFICE that have arrears (1) between 100-5000 (2) between 5001-10000 (3) 10001-15000.
Example District AA has 4,000 cases with arrears between 100-5000 and 2000 cases between 5001 and 10000 and 1000 cases between 10001 and 15000. The DISTRICT_OFFICES ARE AA,BB,CC,DD,FF,GG,HH,II,JJ,KK,LL,MM,NN,SS,UU,VV,WW . I probably didn't explaine that very well. Thanks again for giving it a look and if you have time later and could give it another look that would be great. Mike

Donna, I'm sorry. All I need to do was add the DISTRICT OFFICE field and this works great!! Thanks for your help. Mike

Hi Mike,

Glad to help - at least you managed to sort out what it was you needed.

Thanks,

Donna