Row calculations

[Mikko Saavalainen]

Hello
I do have a table which includes certain rows and the amount in column January is
for example 1000 in row 100
I would like to get next row ( 101 ) a value which is 10 % of previous value , what would be the best way to calculate row values , column values are easier to caculate but what about row values ???

[MMcCarthy]

Hello
I do have a table which includes certain rows and the amount in column January is
for example 1000 in row 100
I would like to get next row ( 101 ) a value which is 10 % of previous value , what would be the best way to calculate row values , column values are easier to caculate but what about row values ???

The only way to identify a row in access is by the unique identifier/primary key. There is no way to get the 'row no.'.

Mary

[NeoPa]

Working within records (rows) is handled very well in any SQL RDBMS.
Working between records is not. It is extremely complex and requires code except in very limited cases.
Reports can keep a running sum but that and GROUPing are some of the few ways it can be achieved.
You can apply a 10% markup on one column and display it in another. To do this by row would be very complicated and require code.