Decimal half (.5) displayed in report as fraction
On 24 Apr, 16:28, Marshall Barton wrote:
wrote:
On 24 Apr, 14:43, Marshall Barton wrote:
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, "½", "")
OK
I adapted it to the name of the field, so I used
=Int([Home For]) & IIf([Home For]-Int([Home For])0,"½","")
But I get #Error
Change the name of the text box from [Home For] to something
other than the name of a record source field, eg. txtHomeFor
--
Marsh
MVP [MS Access]- Hide quoted text -
- Show quoted text -
Marsh comes to my rescue again
Thanks!
Neil
|