Looping

  • Thread starter Thread starter Cam Edge
  • Start date Start date
C

Cam Edge

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.
 
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
 
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
 
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)
 
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
 
Back
Top