Comparing Two Records

[ntj61c]

How do you compare column A to one record to column B in the next or previos record?

[ranman256]

normally, you wouldnt. Its not really how access works. There are no line#s.
But, if you have an index on the record you could pull the 2 records in a query and compare them using the index.

or if you know VB code,
pull the current record data, goto the next record, compare the 2.