I'm not aware of a "feet & inches" data type in Access.
You'll probably need to use either two number-type fields ("feet",
"inches"), or one text-type field (and then create procedures to parse &
calculate).
Two fields is a bit more awkward for users (they have to remember to split
feet/inches into two fields), and one field is more work for you (creating
the procedures, handling mis-entered data, etc.).
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.