I have an Access Query with a last sale date and I need to value each part based on criteria on that last sale date:
LastSaleDate > 08/31/2019 = 100%
LastSaleDate > 08/31/2018 and LastSaleDate <08/31/2019 = 85%
LastSaleDate > 08/31/2016 and LastSaleDate <08/31/2018 = 50%
LastSaleDate < 08/31/2016 = 0%
Can someone suggest a method?
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>