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