Is it possible to combine these five functions into one calculation?
//Truncate ( BendDiameter/12 ;0 )
//Truncate (BendDiameter2ndCal/1 ; 0 )
//Fractions32 (BendDiameter2ndCal - BendDiameter3rdCal)
//If ( BendDiameter4thCal = +1 ; BendDiameter1stCal & "'" & " - " & BendDiameter3rdCal+1 & """ ; BendDiameter1stCal & "'" & " - " & BendDiameter3rdCal & " " & BendDiameter4thCal & """)
What I am trying to accomplish is taking a number that is in inches convert it to feet & inches for a printed display. I can do this with 5 seperate fields one for each each taking 1 step at a time.
Is it possible to use variables in a field calculation? If so how would I structure the formula to use them?
Thanks in advance