How can I do this?

[stew561]

I want to create a report that would calculate the number of leads given to a sales person against what they sold. For example, suppose I have a table named “appointments” with the following fields:

[Appt No] [Rep Name] [Result]
1 Dave Sold
2 Dave Sold
3 Dave Declined
4 Dave Sold
5 Dave Declined
6 Dave Declined
7 Dave Declined
8 Dave Declined
9 Dave Declined
10 Dave Sold


I would like the output of the report to provide me the following:

Rep Name = Dave

Total Appointment = 10
Total Sold = 4
Percentage %40


I really appreciate if someone can give me a hand on this.


Thank You,

Stew

 

[Ron_dK]

I assume that the report is based on a query which has the Appt no, Repname and Results field in it .
Then , create a textbox (Tbox1)in your report and put in the control source :

=DCount("[appt-no]","QryAppointment","[Repname]= 'Dave ' ")

Create another textbox (Tbox2) and put in control source :

=DCount("[appt-no]","QryAppointment","[Repname]= 'Dave ' and [result]='sold' ")

Create a third textbox ( Tbox3) and put in the control source :
=[textbox2]/[textbox1]

Hth

 

[stew561]

I assume that the report is based on a query which has the Appt no, Repname and Results field in it .
Then , create a textbox (Tbox1)in your report and put in the control source :

=DCount("[appt-no]","QryAppointment","[Repname]= 'Dave ' ")

Create another textbox (Tbox2) and put in control source :

=DCount("[appt-no]","QryAppointment","[Repname]= 'Dave ' and [result]='sold' ")

Create a third textbox ( Tbox3) and put in the control source :
=[textbox2]/[textbox1]

Hth

Thanks, I'll give it a try!

 

[stew561]

Does not seem to work. I keep getting an error