Mar 5 2007, 12:41 PM
This one, I think may be a fun one to figure out. At least I think it will, so I'm posting it.
Board Length = 12
Piece Length (mitre cut) = 5
Scrap = 2 ft per 12 board
So, Board Length/Cut Length = Number of Pieces
Only whole numbers are aloud to make complete pieces.
Now if you take the decimal place (.4 off of 2.4) and multipy it by the cut length you get the exact level of scrap.
If my logic or algreba is flawed please let me know, so I can rethink it.
Thanks in advance!
Is there a way to separate the decimal place from the whole in Access???
Mar 5 2007, 12:46 PM
Use \ (that is a backslash instead of / which is a forward slash) to do integer division. 5\2 = 2.
Mar 5 2007, 01:06 PM
Thanks, I don't really understand. I think I'm looking for a way to get the remainder all alone. You've headed me in the right direction though. Thx.
Mar 5 2007, 01:07 PM
Well the remainder would be 5/2 - 5\2. Anyways, it looks like you got it figured out. Good luck with your project.
Mar 5 2007, 01:11 PM
Also have a look at the Mod operator in addition to the backslash integer division operator
12 Mod 5 = 2
Pieces = (12/5) = 2 pieces
Scrap = 12 Mod 5 = 2ft
Mar 5 2007, 02:03 PM
Brian is right about using the mod operator for remainder. My formula for remainder is wrong. It should be either numerator mod denominator or (numerator/denominator - numerator\denominator)*denominator. Thanks, Brian.
Mar 6 2007, 09:00 AM
I almost forgot, thanks. I had no idea Access was capable of this function!!!!!!!!!!!!!!!!!!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here