Hi, I manufacture products of various lengths, which are cut from a 5m length item. eg 5m length has a 1.2m and a 2.8m cut from it, leaving a surplus of 1.0m. I could have a length .9m which fits the 1.0 surplus, however, if a need a 0.6m length,then its best to use a fresh 5m length as 0.4m would be unsuitable to leave as waste. How can I incorporate this in vba code for it to work in access. I was told it was a "Best fit" scenario, but cant find anything on google, unless I have used the wrong search term. Thanks