Access equivalent of Microsoft Excel Fraction Format Up to Two Digits

[TINMAN]

I have created a report in Microsoft Access which prints out two values for a decimal value in inches say .500 with numerator and denominator in 64ths of if an inch. For this case it will give me a numerator of 32 and a denominator of 64. All of the denominators will be 64 because of the way the database is set up only inch dimensions in increments of 64ths fraction are allowed.

In Microsoft Excel there is cell format which allows a decimal value to be converted to a Fraction Up to two digits in one cell.

Is there any equivalent function or formatting in Microsoft Access which would give me a fraction in one field?

In other words I would like the following numerator and denominator to be displayed as followed for example:

Numerator Denominator Fraction

16 64 1/4


8 64 1/8

Basically what I am trying to do is round the 64th of an inch value to the lowest fraction value.

Thanks for your help.

[June7]

This would be a custom function and has been discussed before. Here is one https://www.pcreview.co.uk/threads/c...excel.3482337/

[TINMAN]

Thanks for the response.

Being a novice Access user I was hoping for something in Access similar to what is in Excel for converting a decimal value to a two digit fraction.

It looks like I am going to have to learn Visual Basic to do what I want to do in Access.