Reformat column

[Guest]

Hi,

I have a table with column that has rates in it.

Table1 Columns = Time; Rate Change

I want to take the Column Rate change and convert it to a fund value that
starts at 1000 and changes based on the rate change.

Time; Rate Change
1 ; 1.05
2 ; 1.05
3 ; 0.95
4 ; 0.95
...... etc.

New Table:
Time; Fund
1 ; 100000
2 ; 105000
3 ; 110250
4 ; 104737.5
5 ; 99500.625
.... etc

Thanks for your help.

 

[Guest]

In your two table examples there appears to my eye to be no algorithm that
would convert from table 1 to table 2.

But that aside; assuming you do have an algorithm that works - - there are
several straightforward ways to work with a Calculated Value. Look up the
term Calculated Value in Microsoft Access web site.

Given there being an fixed algorithm; you can leave the data in the table
as-is - - and present the data as you wish it to be seen in a Form or Report.


Or if you have to do a one time change of the table itself then you can use
a query that will result in the change - - - and make it a MakeTable query....