Just a comment on Richard being unsure about into which range an order of $500 would fall. ie $0 to $500 or $500 to $1000. Logically the ranges shouldn't overlap and 500\500 = 1 (placing it in the $500 to $1000, whereas the highest currency value that can be in the first range must be $499.99 ie $499.99\500 = 0 Integer division forces the ranges to be $0 to $499.99, $500 to $999.99 etc No need to have created an order of exactly $500 to test this - but it was a thoughtful way of proving the point.
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 12.
