I am new to this forum and to advanced Access 2013 features
I have developed a database to catalog my clearance inventory and to determine how items should be priced based upon age.
There are columns in the table for "date of arrival", "current date", "product age", "cost" and "discounted price".
"Product age" is a calculated column subtracting "date of arrival" from "current date"
The number of days determines what mark-up is applied.
Example:
0 to 30 days equals "cost" / 0.6
31 to 60 days equals "cost" / 0.7
61 to 90 days equals "cost" / 0.8
91 to 120 days equals "cost" / 0.9
I have attempted to use the expression builder using "IIF" but with not success. I have also attempted to use the macro builder but that has failed as well.
Can someone give me some direction please?
Thank you