Number to Feet and Inches

[Jason Rhymes]

Is there a way to convert a number to show feet and inches in a report?

 

[PC Datasheet]

Put the following in the control source property of a textbox:
=[YourNumber]/12 & "Ft. and " & [YourNumber] Mod 12 & "in."

 

[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

 

[Jason Rhymes]

Thanks, now it works.

 

[Ken Snell [MVP]]

PC just flipped the division sign the wrong way:

=[YourNumber]\12 & " Ft. and " & [YourNumber] Mod 12 & " in."