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

Calculate a value using values in preceding or subsequent records

P: n/a
max
I have a field containing total sales. What I would like to do is
create a new field that would show the difference in sales from either
the preceding or next record. I know this could be accomplished easily
in Excel but I would like to do it in Access if possible. I guess in a
general sense, how do I reference a value in another record to be used
in the current record. Thanks

Nov 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/kb/210504/en-us

(This is a very different task in a relational database than it is in a
spreadsheet.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"max" <ms****@yahoo.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
>I have a field containing total sales. What I would like to do is
create a new field that would show the difference in sales from either
the preceding or next record. I know this could be accomplished easily
in Excel but I would like to do it in Access if possible. I guess in a
general sense, how do I reference a value in another record to be used
in the current record. Thanks

Nov 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.