Converting a field to inches

[Paul Blake]

Hi.

When entering the height and width of a garage door I enter it into 4 fields:

<<Height-Ft>> + <<Height Inches>>

<<Width-Ft>> + <<Width-Inches>>

It looks like this on the printed quote...... Height = 11' 7" Width = 12' 4"

-------

Is there a way for me to add those 2 fields together and show the Height total and Width Total in Inches??

Any help would be valuable and appreciated. Paul.

[No_access]

if you wanted to show it as 139 x 148

Use a calulation fields "Text"

(height-ft*12)+height inches & " x " & (width-ft*12)+width-inches

[comment]

Hopefully, your field names do not contain a minus sign.