Assigning values to duplicate records

[matteu1]

I have a query with with four fields:

Property


Unit
Square Footage
Start Date

I've created a 5th field called End date. What I'd like to do is have the query look for duplicate unit records by property. If a duplicate record exists then assign an end date to the superceded unit's square footage. The end date would equal the start date of the new unit's square footage.

Example:
House, 101, 1,000, 1/1/09, 5/1/09
House, 101, 1,200, 5/1/09, n/a

Thanks in advance,

Matt

[pbaldy]

It sounds like you want the reverse of this:

http://www.baldyweb.com/PrevValue.htm

[matteu1]

Yes I do. All I did was switched max to min, and reversed the < to >. Much thanks!

[pbaldy]

No problem, glad it helped.