l0knezmonstir
Technical User
Using Access 2000.
I need a query to do this..
Each rep has a number of schools. (treps, tschools joined on repid) Each school has an estimated quantity field. (04QTY) I need to count, for each rep, how many schools have quantities filled in. (ie john q rep has 5 filled in) I was able to pull this off, but only using a report. I then need to count how many reps have 1 school filled out, 2 filled out...up to 10 and then a greater than 10 count. I can do this in excel using dcount and the exported report that counted the number for each rep. Its rather obnoxius though.
So basically i just need something that looks like this
68 0
32 1
23 2
28 3
21 4
22 5
13 6
16 7
9 8
3 9
14 10
45 >10
Any ideas?
-Marty
I need a query to do this..
Each rep has a number of schools. (treps, tschools joined on repid) Each school has an estimated quantity field. (04QTY) I need to count, for each rep, how many schools have quantities filled in. (ie john q rep has 5 filled in) I was able to pull this off, but only using a report. I then need to count how many reps have 1 school filled out, 2 filled out...up to 10 and then a greater than 10 count. I can do this in excel using dcount and the exported report that counted the number for each rep. Its rather obnoxius though.
So basically i just need something that looks like this
68 0
32 1
23 2
28 3
21 4
22 5
13 6
16 7
9 8
3 9
14 10
45 >10
Any ideas?
-Marty
