Hello everyone. I'm new to the forum and just starting out in access, so please bare with me.
I'm creating a database to store vehicle inventory. I'd like to add the functionality of a button that will automatically calculate our sales prices.
We use a "tiered markup" system, whereby the higher the cost of the item, the less markup we make off of it. We have 3 different markups that we use for each item. For this, I think I should use a seperate table. The table designates 3 different markups for different price categories (one for less than $$$, one for between $$$ and $$$$, etc.)
So far, my thoughts are for the user to enter the cost and click the button. I was thinking about using on onClick expression and a dlookup to draw in the correct markup and calculate it all in the expression. Unfortunately, this is proving to be not only functional, but I believe also overly complicated.
The markup table would need to compare the cost and draw out 3 sets of numbers (the "mark up"). At this point, 3 different fields would be filled on the current record (adding each of the markups to the cost) - Net price, low retail & mid retail (the 3 different mark up levels).
This all seems confusing to me, so I hope that it's clear enough for you folks to understand.
Currently, I'm having a tough time figuring out if I should be looking at queries, macros, or VB code. I'm really looking to be pointed in the right direction. I'll research and ask questions as necessary, so I'd really like suggestions on the best way to accomplish this. Thanks in advance!