Enter measurement as feet / inches

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"?
 
J

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...
 
B

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.
 
P

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)




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top