change from inches to feet

[Dennis Villareal]

i have a table that pulls the length of my material in inches. Meaning i
have a 24' product and it shows 288. is there a way to convert what it shows
in my queries to feet? the field is a number field and that table cannot be
edited by me.

table is set up as

field size - Decimal
format -
precision - 9
scale - 4
decimal places - auto
imput mask -
caption -
default value -
validation rule -
validation rule -
required - yes
indexed -
smart tags -

then in Lookup

display control - text box

any help?

thanks

 

[John Spencer]

divide by 12

288\12 will return the number of feet as a whole number
288 Mod 12 will return any remaining inches.

The expression
290\12 & " ft " & 290 Mod 12 & " in"
returns 24 ft 2 in

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Dennis Villareal]

thanks

LENGTH: ([PRD_LGTH]/12)

works good for me. i couldn't get the other one to work where the inches is
seprate, but this one should work well enough

thanks for your help.