Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Probably. It sounds like the kind of problem discussed here: Compare one column each cell value with next column accumulated values - coverage ratio
I attached the program so you can take a look at it. Thanks.