A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Decimal half (.5) displayed in report as fraction



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2010, 10:26 AM posted to microsoft.public.access.reports
[email protected]
external usenet poster
 
Posts: 60
Default 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
  #3  
Old April 24th, 2010, 03:14 PM posted to microsoft.public.access.reports
[email protected]
external usenet poster
 
Posts: 60
Default 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
  #5  
Old April 24th, 2010, 04:34 PM posted to microsoft.public.access.reports
[email protected]
external usenet poster
 
Posts: 60
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.