Thread: Decimal half (.5) displayed in report as fraction
View Single Post
  #2  
Old April 24th, 2010, 02:43 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
  
Posts: 5,361
Default Decimal half (.5) displayed in report as fraction
wrote:
In my table of results, if a race is a dead heat, it is recorded with
a decimal ".5"

On my report I wish to show it as ½ - for example, the points scored
might be 696½

It is never .25 or .75 etc. The values in the field will be whole
numbers or with the .5


Try a text box expression like:

=Int(points) & IIf(Points - Int(points) 0, "½", "")

--
Marsh
MVP [MS Access]