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?

ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
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

ASKER

That worked perfectly. thank you!