Link to home
Start Free TrialLog in
Avatar of Mark Drelinger
Mark DrelingerFlag for United States of America

asked on

create a value based on LastSaleDate

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?

Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Drelinger


That worked perfectly. thank you!