By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,396 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,396 IT Pros & Developers. It's quick & easy.

Row calculations

P: 1
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 ???
Dec 5 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 5 '06 #2

NeoPa
Expert Mod 15k+
P: 31,661
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.
Dec 5 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.