If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Storing calculations in form and displaying them on a report
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 |
#2
|
|||
|
|||
Storing calculations in form and displaying them on a report
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 "ChuckW" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
displaying generated date in a form | Joseph Atie | Using Forms | 3 | July 12th, 2004 07:26 AM |
How to show image in the form or report? | JJ | General Discussion | 1 | June 29th, 2004 06:01 AM |
Displaying A User Form With A Macro When User Opens Powerpoint | Olan | Powerpoint | 6 | June 22nd, 2004 09:35 AM |
Displaying Comma's on a form | Ronnie | Using Forms | 4 | June 10th, 2004 10:27 AM |