Field reference

[Spook1776]

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 ...

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504