Instead of computing the Discount Amount in Lesson 01 of Access Expert Level 9, I use the following calculation: DiscPrice: Round([ExtPrice]*(1-[DiscountRate]),2). This calculates the customers cost in 1 step instead of 2 and eliminates the need to calculate the DiscountAmt and then subtract it from the ExtPrice.
Oh sure... You can usually take multi step operations and condense them into fewer steps. It's a mix between fewer steps and readability. I find it's easier to teach (and for beginners to understand) if I use more steps.
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
Access Expert 9.