A query to add five years on the fly to all the rows in your tblAssets might look like this:
Code:
SELECT *, DateSerial(Year(Purchased_Date) + 5, Month(Purchased_Date), Day(Purchased_Date)) AS Replacement_Date FROM tblAssets
Let's say you had a field in the table that provides the expected life span of the asset, then some things might be 3 years, others might be 5 years, and you can still query the replacment date in one query. Assuming this field is called LifeSpan and is a number data type in years:
Code:
SELECT *, DateSerial(Year(Purchased_Date) + LifeSpan, Month(Purchased_Date), Day(Purchased_Date)) AS Replacement_Date FROM tblAssets