I have a field that is calculated by users input of these two values, TonsperDay * PourDays. The user then has to manually select a Pour Date range until another field, Net Good Tons, is close and/or equal to the calculated value. This is hit and miss until the numbers get close. My users would like this to happen automatically so they do not need to manually select Pour Dates but the program will do this based on the calculated value. Keep in mind that the calculated value will most likely never equal exactly the Net Good Tons because Net Good Tons is based on actual order tonnage and they are rarely even numbers. Is this possible?
Message was edited by: James Walsh - I added the report so you can see the program.
