If this comment has already been brought up, I apologize... Wouldn't it be better to have your price be a certain percentage of your cost? Then when your costs go up, your prices go up by a certain percentage automatically and you're not having to update twice the number of fields? :-)
Reply from Richard Rost:
That's certainly an option for some situations. If you want to set up your database that way, then that's fine. What if you have a particular product that is a good seller and you advertise it for $14.99, then your costs go up a little bit. You don't want to kill your promotion over a few cents. Always making your prices a function of cost can be troublesome.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 311.