expression for invoicing $2.00 per unless under 25 or over 751?

[Guest]

I am using access 2003 and am trying to create an invoice in "REPORTS" that
will calculate the membership fees based on the number of students enrolled.
I need it to calculate the following excpetions. If the #of students is 1-25
= flat rate of $50.00; 26-750 is $2.00/student; 751- = flat rate of $1500.00.

 

[Guest]

In the Control Source property of your text box for the Fee,

=IIf([Students]<26,50,IIf([Students]>750,1500,[Students]*2))

Assuming that you have a field named Students on your invoice that contains
the number of students.

You could also use this expression in a query to calculate it there, if
necessary.

 

[Jeff L]

I am assuming you have a field in a query that counts the number of
students in the class. Put the following in a field on the Report.

=iif(NumStudents <=25, 50, iif(NumStudents >=751,1500,NumStudents * 2))

Hope that helps!

 

[Guest]

Thank you so much Bryan! It worked great!

In the Control Source property of your text box for the Fee,

=IIf([Students]<26,50,IIf([Students]>750,1500,[Students]*2))

Assuming that you have a field named Students on your invoice that contains
the number of students.

You could also use this expression in a query to calculate it there, if
necessary.

I am using access 2003 and am trying to create an invoice in "REPORTS" that
will calculate the membership fees based on the number of students enrolled.
I need it to calculate the following excpetions. If the #of students is 1-25
= flat rate of $50.00; 26-750 is $2.00/student; 751- = flat rate of $1500.00.