Storing calculations in form and displaying them on a report

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am working on a form called PotentialRevenue that will
calulate potential revenue and compares it to actual
revenue. A user plugs in a start date and an end date
which are text boxes on a form called txtStartDate and
txtEndDate. There is then a combo box which displays a
list of all of our customers called CustomerAll which is
based on a query of a customer file called CustomerAll.
This will then query a transaction table and calculate
the actual revenue on an access report. I can do this
part but I am having trouble figuring out how to
calculate the potential revenue.

What I want to do is the have text boxes on this same
PotentialRevenue that contain various variables such as
NumberOfPatients and RevenuePerPatient. When you
multiply these two variables together you get the
Potential Revenue. I would then want to subtract the
actual revenue from the potential revenue and call that
RevenueGap on my form.

So what I want to do is to have a user select a start
date, an end date, a customer and then the various
variables and then create a report that will calculate
the acutal and potential revenue and the revenue gap.

Can someone help me figure this out?

Thanks,

Chuck
 
In the "on change" event of the NumberOfPatients and RevenuePerPatient text
boxes, update the value of the PotentialRevenue text box like
me.PotentialRevenue = me.NumberOfPatients * me.RevenuePerPatient. Then just
refer to the PotentialRevenue textbox on you Report

rh
 
Back
Top