If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Decimal half (.5) displayed in report as fraction
Hi
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 Is this easy to do? Thanks Neil |
#2
|
|||
|
|||
Decimal half (.5) displayed in report as fraction
|
#3
|
|||
|
|||
Decimal half (.5) displayed in report as fraction
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, "½", "") -- Marsh MVP [MS Access] 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 Neil |
#4
|
|||
|
|||
Decimal half (.5) displayed in report as fraction
|
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|