Look back at the tables I suggested. Look at TblFractionPart.
DecimalOfFractionPart gives you the decimal.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications





"KevinKBM" wrote in message
...
STOP THE PRESSES!!

Ok i now have the text boxes accepting fractions.
and that gave me a idea.

in After Update will it work if i had it convert the fraction (in text) to
decimal, then send that to a query to do the math in and then have that
report the rounded up total to the final box?

that should make things far more simple.
the converter will have to read a text based fraction, in the format of
(##/##)

think that will work? and if so, how do i do it?
thats everybody you have all be most helpful