How to compare data in one field for different records.

message from =?Utf-8?B?U29waGlh?= on 3 Jun 2004
I want to compare the date in one field in a table for different records. How to write the query?
 
Allen Browne replied to =?Utf-8?B?U29waGlh?= on 4 Jun 2004
ACC2000: Referring to a Field in the Previous Record or Next Record
at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc2000
 

Archived message: How to compare data in one field for different records. (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.