 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Field reference
Access 2000 I want to know if it is possible to reference the previous value in a field when designing a query. Query A: Field1 Field2 Field3 Field4 ... . . . XYZ ABC DEF EXPR4: current record:Field2 + previous record:Field3 . . . If the data were: . . 1 2 3 18 4 5 6 ?? Then ?? would be 8 See: Referring to a Field in the Previous Record or Next Record at: http://support.microsoft.com/default.aspx?scid=kb;en-us;210504  SignatureAllen 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. > Access 2000 > [quoted text clipped - 22 lines] > > Then ?? would be 8 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.