I am having difficulty figuring out how to deal with fractions. The database that I am designing is for a company who's industry standard nomenclature is in fractions. For example, 5-3/4", 1/2", 3'2", etc. I need to perform mathematical operations on the user's input. For example, if the user enters the fractional values 1'2-3/4" (14.75 inches) and 5-1/2" (5.5 inches), I need to determine that the sum of the values is 1'8-1/4" (or 20.25 inches).
Does anyone have any ideas how to enable the user to use fractions for input (and use fractions for output - reports, etc) but still let me convert them to a decimal value?
Help!
Does anyone have any ideas how to enable the user to use fractions for input (and use fractions for output - reports, etc) but still let me convert them to a decimal value?
Help!
