Using Else Or Else if Statements in Access 2007

I'm creating a Bid Sheet for an auction where I would like bid value labels to be included on a report based upon the [Estimated Value] of the item. I'm able to calculate a [Starting Bid] in a query (1/3 of the Estimated Value of the item). I would like the [Starting Bid] to be the first line item on the Bid Sheet. I would like additional amounts included on report at set increments. If the [Estimated Value] is between $1 and $99, I would like the incremental value to be $5. If the [Estimated Value] is between $100 and $299, I would like the incremental value to be $10. If the [Estimated Value] is between $300 and $499, I would like the incremental value to be $15. And if the [Estimated Value] is greater than $500, I would like the incremental value to be $25. I'm able to get my report to show two incremental values using an IIf Statement in my Query to set the value of [Increment]. Unfortunately, I don't know how to use it for more than two condition
s. Can I use an Elseif statement (or something else) in the Query? If so, what would the statement be? If I need to set the Increment Value in the Report, how would I do that? Thank you.

I think you need to be careful not to confuse business rules with program logic. Program logic tends to stay the same over time, while business rules are liable to change. I would think that your bid increments for various price brackets would fall into the category of business rules.

If you write business rules into your code (either in VBA or SQL, or in the design of your forms or reports) then, when the business rules change, you will have a big job to find and change every expression of that rule in your code.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.