The example is simply a home sales table set up this way ID DateSale SaleAmount The table tracks all the sales that takes place in a community for the homes. A single home can be sold numerous times over its lifespan. So the challenges is to compare one sale amount to the next by date of sale. I need to calculate the difference between each sale and determine the % increase or decrease. I hope this helps. Dale A. Young