 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Looping
Hello I have a form with multiple lines of profit share information on it - I can calculate the results of each line, but I need to be able to take the sum of one line and then add (loop) it to the next line and so on until all lines have been added. I would appreciate some help on this please Tks Cam Forms display data in Access, tables store it. What does your data look like (not how you've displayed in on a form)? I ask because how you query it for reporting will depend on how you've stored it.  SignatureRegards Jeff Boyce <Office/Access MVP> > Hello > I have a form with multiple lines of profit share information on it - I can [quoted text clipped - 5 lines] > > Cam Jeff Name Year Profit Paid EI CPP Tax Int. Rate Investment Employee Contribution Co. Pd for Contr EDGEPAT 1986-87 $733.97 $17.25 $9.98 $85.52 9.25% $0.00 $0.00 EDGEPAT 1987-88 $1,780.61 $41.84 $31.27 $376.12 9.50% $0.00 $0.00 EDGEPAT 1988-89 $2,324.97 $45.34 $44.10 $456.98 11.00% $0.00 $0.00 EDGEPAT 1989-90 $1,141.80 $25.69 $19.99 $0.00 11.25% $0.00 $0.00 EDGEPAT 1990-91 $2,523.90 $56.79 $52.30 $0.00 7.50% $0.00 $0.00 EDGEPAT 1991-92 $2,474.99 $74.25 $53.00 $0.00 9.50% $0.00 $0.00 EDGEPAT 1992-93 $2,635.42 $79.06 $59.01 $0.00 4.50% $0.00 $0.00 EDGEPAT 1993-94 $3,337.27 $102.45 $79.40 $0.00 9.50% $0.00 $0.00 EDGEPAT 1994-95 $2,293.70 $68.81 $54.28 $0.00 8.00% $0.00 $0.00 EDGEPAT 1995-96 $5,378.78 $95.88 $148.47 $0.00 5.00% $0.00 $0.00 EDGEPAT 1996-97 $5,852.20 $169.71 $154.12 $100.00 4.00% $0.00 $0.00 EDGEPAT 1997-98 $6,440.04 $173.88 $196.75 $182.46 3.25% $0.00 $0.00 EDGEPAT 1989-9 $5,576.76 $142.21 $175.55 $0.00 4.00% $0.00 $0.00 EDGEPAT 1999-00 $6,198.93 $148.77 $241.76 $0.00 4.00% $0.00 $0.00 EDGEPAT 2000-01 $5,364.03 $120.69 $230.65 $2,260.90 2.50% M $0.00 $0.00 EDGEPAT 2001-02 $2,727.78 $0.00 $0.00 $0.00 2.50% $0.00 $0.00 EDGEPAT 2002-03 $2,289.75 $0.00 $0.00 $0.00 2.00% $0.00 $0.00 EDGEPAT 2003-04 $3,300.96 $65.36 $163.39 $0.00 2.00% M $0.00 $0.00 I need to calc as follows =((ProfitPd - (EI-CPP-TAX))*Tax )+Employee Contribution + Co. Pd for Contr - take this calc and add it to the next line and so on Cam From the data and formula you provided, I suspect you could: * create a query that calculates the value for each row * create a report and include an extra control that you set to display the "Running Sum" of that calculated value (see Access HELP) SignatureRegards Jeff Boyce <Office/Access MVP> > Jeff > [quoted text clipped - 41 lines] > > Cam Jeff Correct I can do that but I need to take the end result of each line and add it to the next line. The scope: Each employee is given a sum of money (ProfitPd) each year that they have to invest and account for that money each year. We deduct (EI, CPP, Tax)certain things from that money before we calculate a possible interest rate he can get for the money (INT) the end of the line value could be as follows - $5-$1-$1-$1 = 2*1.025 = $2.05 Now next year he is given (ProfitPd) money again. Another $5 - What I need is to take the total ($2.05) from the first line and add it to the money (ProfitPd) on the next line (=$7.05) and then do the calculations all over again for the next line. To me this is a loop scenario and I would like to know how to do that please. Many Thanks Cam Jeff Fields Name Year Profit Paid in $ EI in $ CPP in $ Tax in $ Int in $ Rate in % Investment Employee Contribution in $ Co. Pd for Contr in $ The calculation for each line is as follows (Profit paid - EI - CPP -Tax ) * Rate = Int Then Profit paid + Int This is the total for one line Then I need to add this to the Profit paid on the next line and follow the same procedure on each line accumulate the value that the person has I hope you understand this - I have it done in Excel but now I would like to use Access Tks again Cam |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.