Calculations on Report

A

Amanda

Hello,

I am working on a report. I want to make a calculation
based on another calculation in the report. For example I
have the average amount of money made per phone call. I
want to find out how many phone calls need to be made to
achieve a certain goal.

Any idea how to use a report field calculation in another
calculation?

Amanda
 
C

Charlie

Put the following in the Control Source of a new control
on your report.

=([GoalAmount]/[AmtPerCall])

Charlie O'Neill
 
Top