Enter measurement as feet / inches

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Is there a way to enter into a field the measurement in
feet and inches - to have a format that is 4' - 6"?
 
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...
 
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.
 
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)




.
Click to expand...
 
Back
Top