Enter measurement as feet / inches

[paul]

Is there a way to enter into a field the measurement in
feet and inches - to have a format that is 4' - 6"?

 

[James Goodman]

Not sure, but would it not be better to have two columns, one for feet & one
for inches? You could concatenate the two in a query...

 

[Brendan Reynolds]

Not unless you use a text field, in which case you'd have to parse the text
and change the two parts back to numbers before you could perform any kind
of calculation on the data. I'd go with James's recommendation elsewhere in
this thread - store them in two separate fields and concatenate them as
necessary for display purposes.

 

[paul]

Thanks everyone!

-----Original Message-----
Not unless you use a text field, in which case you'd have to parse the text
and change the two parts back to numbers before you could perform any kind
of calculation on the data. I'd go with James's recommendation elsewhere in
this thread - store them in two separate fields and concatenate them as
necessary for display purposes.

--
Brendan Reynolds (MVP)




.