is there a "fraction" number format?

[Guest]

I want to format numbers in Access 2002 as fractions e.g. 23.625 as 23-5/8"
-- is this possible?

Thanks

 

[Allen Browne]

There is no native format for this, but Microsoft did release a database
with sample code for converting from/to fractions for display. Try:
http://support.microsoft.com/default.aspx?scid=kb;en-us;148402