Test against different rows

[ooch1]

Hello,

I was wondering whether it is possible to test against different rows within a table or query.

For example, if my data is set out as follows:

MPR Contract P/unit Status
100 2500 1.99
100 2501 1.99 Contract Update
200 1000 1.99
200 1000 2.01 Price Update

What i would like to do is go down each row and where there is a change in either price or contract then update the status as suggested.

I am not to sure whether this can be acheived, as i cannot find any row or column functions?

All suggestions welcomed!!

OOch

 

[SJMcAbney]

This is a double post:

http://www.tek-tips.com/viewthread.cfm?qid=985925&page=1

Stewart