J
Jason Rhymes
Is there a way to convert a number to show feet and inches in a report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PC Datasheet
Put the following in the control source property of a textbox:
=[YourNumber]/12 & "Ft. and " & [YourNumber] Mod 12 & "in."
=[YourNumber]/12 & "Ft. and " & [YourNumber] Mod 12 & "in."
J
Jason Rhymes
Thanks, that's close but the output is screwed up on some. Example, I have
this: 1.05416666666667Ft. and 1in. for 12.62
this: 1.05416666666667Ft. and 1in. for 12.62
J
Jason Rhymes
Thanks, now it works.
K
Ken Snell [MVP]
PC just flipped the division sign the wrong way:
=[YourNumber]\12 & " Ft. and " & [YourNumber] Mod 12 & " in."
=[YourNumber]\12 & " Ft. and " & [YourNumber] Mod 12 & " in."