I would like to get some help working out a formula to obtain the feet - inch value based on a inch value.
If I have a value of 244 inches
I would like to convert it to 20 feet .333 inches (rounding up/ down the inches value would be great)
and then save each calculated value to a separate record set field like:
rsData("BoxLength_Feet") = 20
rsData("BoxLength_Inch") = .333
I hope this is not much trouble but I really need the help.
Thank you very much.