How do I compare two successive records of the same field and dis.

[Guest]

How do I compare two successive records of the same field and display the
greater number in the first record of a new field using an Access Query?

 

[Tom Ellison]

Dear Raju:

If the "two successive records" are successive in the context of a
unique index, then this can be done using a correlated subquery. I
have found an easy way to show this in the newsgroup is to have you
write a query that displays the desired values from the first of the
two rows. Please describe what you want to show from the second of
the two rows. Also specify the column(s) on which the unique order of
your rows depends.

Post that query here and I'll try to fill in the rest of the query
work and describe what it's doing.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts