What calculation would I need to convert inches into feet & Inches in a field? Like 24 to 2” 0”

Floor(inches / 12) & "' " & Mod(inches;12) & """

Edited August 22, 200817 yr by Guest

Thanks, but I guess I need to explain. I have a look up field that pulls height in inches (like 72) from another table field and when FM performs the look up I want the field to display (6' 0")

Edited August 23, 200817 yr by Guest

If you don't need to keep the 72 around, just change that lookup into an auto-enter calculation using the calc provided by Quartekoen. Change "inches" to the name of your related inches field, of course.

If you do need to retain the value in inches, keep your lookup, and create a second field with an auto-enter calculation as above.

Thanks, I figured it out.. Thanks both of you.